SQL Server 2012 Certifications Revamped
Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...
2012-05-21
4,314 reads
Blog Posts
SQLSaturday #119 Chicago – In the Books
As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room. The SQLSaturday #119...
2012-05-21
749 reads
SSRS: FORMAT option for milliseconds
Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a...
2012-05-21
2,020 reads
Denali – Day 20: More Programmability Feature
Denali – Day 20: More Programmability Feature
Native XML Web Services (SOAP/HTTP endpoints) is Removed:
Earlier version of sql server support Web services...
2012-05-20
933 reads
Dynamic Stored Procedure Execution in SQL Server
In my previous blog post: Suggestion: “USE” Keyword with Linked Servers, I talked about the suggestion I’ve posted on Microsoft...
2012-05-20
523 reads
MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,683 reads
SQL Server Memory Usage - Task Manager
Another question I have answered 100s of times to Non SQL folks. "SQLServr.Exe is consuming 80% of memory. Can you...
2012-05-20
1,424 reads
Denali – Day 19: Programmability Feature -T-Sql
Denali – Day 19: Programmability Feature -T-Sql
ORDER BY .. OFFSET and FETCH :mysql LIMIT (srno ):
OFFSET is a location of the rows...
2012-05-19
1,025 reads
Promised Links from SQL Saturday 119 Presentations
If you attended one of the sessions I promised to post the links we discussed here. I have done my...
2012-05-19
1,130 reads
Build a Little Free Library
I saw this on the Boing Boing feed yesterday, Little Free Library is a project to try to build 2500...
2012-05-18
843 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