-
Often, students and colleagues come up to me and enquire how do they get started learning about some of the newest technologies. They generally do not seem to have issues with getting the study materials (most common study materials are the many blogs on the Internet and MSDN documentation). The one...
-
I would start today’s post with a question – Have you ever faced a requirement to delete a job once it successfully completes? Once I had to achieve just that – a SQL Server job had to be created, and the requirement was to delete the job after it’s execution. Now, the job was a scheduled data cleanup...
-
Well here it is the next version of SQL Server is getting out step by step, few months ago CTP3 and now Release Candidation 0 is available for download. The version number will be 11.0.1750.32, make a note of it. Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help...
-
Earlier this week, I had explored why the sequence of index creation is important in a rather long post on performance tuning. You can read the post here: SQL Server – Performance – Best Practice – Create Index Before or After a data insert? Today’s post, therefore, will be a nice, small one – something...
-
SQL Server 2012 is a big release compared to what we have seen from 2005 to 2008, though R2 has been an additional release with BI capabilities. Now SQL 2012 equipped with much more enhancements and new features to manage your data platform. In specific to this release its good to know about new edition...
Posted to
SQLMaster
by
Satya Jayanty
on
11-04-2011
Filed under:
Filed under: best practices, enterprise edition, beginners, dba practices, editions, setup, Business Intelligence, installation, licensing, sql server 2012, standard
-
Well, its time now again for all DBAs and System Administrators out there to do some real-world testing on their SQL Server 2008 instance platform, service pack 3 for SQL Server 2008 is released now. If you are already testing the CTP version then its not a big issue to perform the test and upgrade the...
-
SQL Server 2008 R2 has opened gates for endless opportunities for Organisations & Developers to take advantage of newest technologies. I'm getting to know these new features such as PowerPivot Features , the technical documentation refers that PowerPivot workbooks are like Excel workbook (.xslx...
-
Lunch time for me, is time to refresh myself. It’s a time when I try to daily to take 10-15minutes out of my lunch time to close my E-mail client, stop all work and take my mind away from the day’s work. I spend the time learning about anything I am in the mood for – science, sports and SQL Server (of...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-29-2011
Filed under:
Filed under: Development, Administration, T-SQL, Performance Tuning, Tips, SQL Server, Denali, #SQLServer, #TSQL, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Myths, Debugging
-
Ever since anyone starts learning Microsoft SQL Server, a misconception sets in. The misconception is that data and log files can be defined as under: File with extension - .mdf - is a Primary data file File with extension - .ndf - is a Secondary data file File with extension - .ldf - is a log file These...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-26-2011
Filed under:
Filed under: Administration, Tips, SQL Server, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Myths
-
SSMS, or SQL Server Management Studio is a wonderful tool, and those who frequent this blog will notice that I tend to try and make day to day task simpler using the SSMS. In a development environment, databases are created and backups restored often. Most developers have rights to the development instance...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
06-22-2011
Filed under:
Filed under: Administration, Tips, SQL Server, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Connect Cases
-
Today’s post takes me back to the days when I was learning SQL Server at the engineering school about 8 years ago. I learnt SQL 7 and SQL 2000 and then as I joined my present employer, SQL 2005 came along. While SQL 7/2000 had the Enterprise Manager, SQL 2005 onwards we have the SSMS – SQL...
-
I was asked from so many people by one question, "Can we installed multiple versions of SQL Server in same machine?"and complained about about errors while installation of multiple versions. What's your answer? My answer is Yes. Here is the snap which my machine running multiple versions...
Posted to
sqlideas
by
Paresh Prajapati
on
04-22-2011
Filed under:
Filed under: sql, sql server 2008, sql server 2005, sql server, ms sql, sql server errors, ms sql server, sqll server 2011, sql server denali, Installation, #SQL Server, version
-
In earlier post I wrote the all the SQL Server 2011 (Denali) new features and enhancements and i promised to write the post in details for the new features. I have already posted the article in earlier post, how to install SQL Server 2011. I hope you have already downloaded and installed it. Today i...
-
I am very happy today because I downloaded SQL Server 2011 (Denali) CTP1 and installed in my machine. Also getting started to write the post for the SQL Server Denali. Write now I want to getting started with the installation of SQL server 2011 as how can we install. Here are the some of steps and snaps...
-
Since the start of the week, I am attempting to explore the concept of contained databases – something that I learnt about during a hands-on lab conducted by Jacob Sebastian. Please read my posts Part 01 , Part 02 and Part 03 in case you missed them. To get us back into context, let’s revisit the definition...
Posted to
Nakul's Blog
by
Nakul Vachhrajani
on
04-13-2011
Filed under:
Filed under: Development, Administration, T-SQL, Tips, SQL Server, Denali, #SQLServer, Best Practices, Guidance, Installation, DBA, SSMS, Tools and Utilities, Community, Series, Tech-Ed, #techedin