SQL Server DBA Blog, with straightforward advice, quality resources and musings about SQL Server
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
Benchmarking: 1-TB table population (part 3: separating data and log files) – Here’s the next instalment in this excellent series from Paul Randal.
How to Make SQL Server Backups and Restores Faster – No nonsense, effective tips [...]
I hope you’ve had a great week.
One point that deserves a special mention this week is that there will be a Service Pack 4 for SQL Server 2005 following on from much debate and pressure from the SQL Server Community. For full details of the service pack release schedule see the Microsoft SQLReleaseServices Blog.
Here’s this weeks roundup of [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
Looking at Page Contents – A little code template here from Michael J Swart.
Why You Might Want to Buy SQL Server 2008 Now – Brent Ozar explains why you may want to look into [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
‘Cannot Generate SSPI Context’ and Service Account Passwords – An interesting case walk-through here from the CSS SQL Server Engineers, albeit quite specialised.
Should PASS hold the conference on the East coast – Is it [...]
I hope you’ve had a great week.
Here’s this weeks, smaller than usual due to the Holidays, roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
sp_db_space_usage – A very nice stored procedure from Tibor Karaszi for reporting database size details.
Getting the ISO Week and Year – Handy little function here with some [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
Delimited String Tennis Anyone? – An interesting look at the performance implications of using XML to process delimited string data resulting from a derived column cast. Brad Schulz discusses.
Those Four Little Words – A [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
How Quest is Bringing DBAs Online – Discover how Quest are harnessing the expert knowledge of DBA’s globally in this post by Brent Ozar.
Finding your Missing Keys – Well defined relationships are a fundamental [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
Comparison: Switching Tables vs. sp_rename – An interesting walk-through that evaluates the differences between using the sp_rename system stored procedure and the partitioning support SWITCH statement, courtesy of the The Database Whisperer (Michael J [...]
I hope you’ve had a great week.
You may have noticed that I have not been around quite so much these last few weeks. Well I can promise you won’t hear any excuses for posting less content from me, that’s just not my style (Apology Accepted). Aside from having enjoyed a well deserved (yes I do [...]
I hope you’ve had a great week.
Here’s this weeks roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!
SQL Server Links
How do CHECKPOINTS work and what gets logged? – A detailed and intricate explanation by Paul Randal of what goes on under the hood of the SQL Server database engine when a CHECKPOINT operations [...]