New Version of ApexSQL Doc (2005.11.0203)
ApexSQL announced that a new version of ApexSQL doc is available.
News Announcement
The latest version is 2005.11.0203 and there are...
2007-03-14
1,519 reads
Blog Posts
Windows 2003 SP2 is Out
Here is a list of what was fixed:
http://support.microsoft.com/default.aspx/kb/914962
Downloads are available off of the SP2 home page:
http://www.microsoft.com/technet/windowsserver/sp2.mspx
Technorati Tags:Microsoft | Windows 2003
2007-03-14
1,465 reads
Conditional formatting in Reporting Services
Yesterday's post reminded me of another interesting technique I have used to change the color of the values on a...
2007-03-11
1,325 reads
Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,714 reads
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,799 reads
Midlands PASS Job Board
In order to assist those members of the Midlands PASS Chapter looking for new positions, I have put up a...
2007-02-26
1,347 reads
Hacked
Boy that was fun. Getting a bunch of emails that we had been hacked and tracking down someone updating all...
2007-02-22
1,514 reads
SP2
Mentioned by Tim Mitchell, but SP2 is out.
Seems more like enhancements to make things smoother and lots of changes in...
2007-02-20
1,454 reads
SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,426 reads
Microsoft SQL Server certification
A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL...
2007-02-18
1,901 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers