|
|
-
|
|
During Tech-Ed (read my 3 part series here – Part 01, Part 02, Part 03), I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL 11 (Code Named: “Denali”). I am currently summarizing these enhancements, and will finally provide a ranki......
|
|
-
|
|
Way back in March 2011, I attended Tech-Ed India 2011 (read my 3 part series here – Part 01, Part 02, Part 03). During Tech-Ed, I learnt about some of the cool new T-SQL debugging enhancements in the next public release of Microsoft SQL Server, SQL 11 (Code Named: “Denali”). In the next couple of po......
|
|
-
|
|
Today, I will be sharing a very small, but important script. Recently, one of the database backups we had received failed to restore. I was faced with a problem of determining whether the problem was with the backup itself, or whether it was an I/O subsystem issue or some other failure.
Like with a......
|
|
-
|
|
SQL Server Management Studio (SSMS) is the one stop shop for almost UI-accessible features of the SQL Server, and an indispensable tool for administrators, deployment professionals and developers alike. Anybody who has ever worked with Microsoft SQL Server ever since SQL Server 2005 came out would ......
|
|
-
|
|
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|
|
-
|
|
Semi-colons as statement-terminators has been around for as long as I can remember, however, they have only been made mandatory in the newer statements. However, as documented in the T-SQL Syntax Conventions, using semi-colons as statement terminators will be required in a future release of SQL Server. However, care needs to be taken not be use them on batch separators....
|
|
-
|
|
Primary data files are always assigned a file_id = 1 in the sys.database_files view. But, what about the log and rest of the data files? Does the primary transaction log file of a database always receive a file_id = 2?...
|
|
-
|
|
Often the most obvious information can be the most confusing - What does the "Number of Users" value in the Database Properties window of the Object Expolrer in SSMS really stand for? This post answers the question....
|
|
-
|
|
If you wish to copy the column headers from the results tab of the SQL Server Management Studio (SSMS) alongwith the results to another program like Excel, use the built-in functionalities of the SSMS demonstrated in this post....
|
|
-
|
|
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say – “simply replace EXEC with calls to sp_executesql and the system becomes SQL injection-proof”. This has to be the biggest misconception of all times around this subject....
|
|