Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and...
2011-09-07
812 reads
Jason Brimhall
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with...
2011-09-06
784 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with the post, I also had meant to get the...
2011-09-06
4 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little warning and error message to greet me. My activation...
2011-09-01
3 reads
Windows 7
The other day I logged on to my backup laptop (Win 7 N 64 Bit) and had this nice little...
2011-09-01
589 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just...
2011-08-31
1,803 reads
Bitwise and Derived Table revisited
Today I am going to revisit two posts from the past couple of weeks. I want to revisit them just to make some minor updates and clarifications. This is...
2011-08-31
7 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else. In SQL, we should be well aware of Precision...
2011-08-24
6 reads
Precision and Scale
As is the case with many of my topics of late, I came across this one by helping somebody else....
2011-08-24
2,862 reads
TSQL Sudoku II
As luck would have it, today I came across this TSQL Challenge. It just so happens that I had already...
2011-08-23
1,079 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,...
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