|
|
-
|
|
The entire TSQL Challenges Team is very excited to welcome Brad Schulz to the TSQL Challenges Team. If you have ever visited the MSDN SQL Server forums, you must have noted Brad’s name as one of the top contributors there. He is a very active blogger and I am a great fan of his recent series of blog......
|
|
-
|
|
For those of you want to learn the basics of storage, there is an excellent series of articles by Brent Ozar. One of the best explanations of the storage basics I have ever seen. The Basics of Storage Where We Store Stuff Scary Storage Scenarios I think they are ‘must-read’ resources fo......
|
|
-
|
|
The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. The following components are available for download as part of the Feature Pack. Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL......
|
|
-
|
|
We are back with the first SQL Server Quiz of year 2011 – TSQL Quiz 2011. The quiz started on 1st March and will run until 31 March 2011. There are 31 questions in this series and a question is published every day. Congratulations to the Winners of SQL Server Quiz 2010 We did a similar quiz a few ......
|
|
-
|
|
Project Crescent is a new data visualization tool that will be part of the next version of SQL Server – code named Denali. “Crescent” is the code name given to the new reporting/visualization tools and it looks like the name may change by the time the product is released. Crescent is expected to r......
|
|
-
|
|
In the previous post, we saw the new TSQL syntax introduced in SQL Server 2011 to support server side paging. We saw the new TSQL keywords OFFSET and FETCH NEXT in the previous post. These new keywords are introduced as an extension to the ORDER BY clause. Let us examine them in detail. OFFSET OF......
|
|
-
|
|
Server Side Paging is a common scenario most application developers must have encountered while creating front end applications that requires paging support. Instead of returning all the rows from the database and implement paging at the client side, you might want to implement the paging on the ser......
|
|
-
|
|
This post tries to explain the behavior of differential backups on a FILESTREAM enabled database. A number of times, I see questions looking for a confirmation whether Differential Backups will correctly backup the NTFS (FILESTREAM) files and restore them correctly when a differential backup is rest......
|
|
-
|
|
This post shows a quick and dirty way of loading a huge file into the FILESTREAM column of a SQL Server 2008 database instance. Note that this is an unsupported method which is not recommended on a production server. The correct way of loading BLOB data into a FILESTREAM column The right way of l......
|
|
-
|
|
I have been playing with FILESTREAM backups for a book that I am writing and came across something that I did not really like. I observed that a FILESTREAM backup may include garbage files which gets restored along with the database. What are garbage files? Let us understand what are garbage file......
|
|