CONCAT in SQL 2012
SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to...
2012-04-19
464 reads
Blog Posts
Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118
Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented...
2012-04-19
557 reads
More IMPORTANT miscellaneous info
This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.
Okay,...
2012-04-19
1,270 reads
PowerShell: Using Exponents and Logs to Format Byte Sizes
In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to...
2012-04-19
3,936 reads
script system object in resource database
When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or...
2012-04-19
1,024 reads
Spend two hours with me at #sqlsat107.
In just two days SQL Saturday 107 will be in full swing. Tomorrow begins their precon with the infamous Kalen...
2012-04-19
640 reads
SQL Server 2012 Performance Test: Gap Detection
Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from...
2012-04-19
3,288 reads
Tribal knowledge is no knowledge
I've run across several incidents in the last couple of months regarding something that is typically called "tribal knowledge." This is...
2012-04-19 (first published: 2012-04-12)
1,302 reads
Using sys.dm_exec_requests to find a blocking chain and much more
As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.
I've added the following features:
The query execution...
2012-04-19
3,461 reads
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE...
2012-04-19
33 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
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