Decryption and CASTing
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,406 reads
Blog Posts
Different ways to move Sql Server file location
Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons,...
2012-07-11
1,022 reads
Many speaking engagements!
I have several speaking events coming up, and I would love to see you there!
First of all, I'll be...
2012-07-11
1,046 reads
Microsoft PivotViewer
Microsoft PivotViewer is a really cool Silverlight web-based control that provides a visual way to interact with massive amounts of data (download)....
2012-07-11
1,317 reads
Quick tip: configure SQL Server authentication mode using T-SQL
SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands...
2012-07-11
1,287 reads
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say...
2012-07-11
12 reads
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s...
2012-07-11
1,280 reads
SQL Lunch #68 – Designing Your First Power View Report
Next week I will be speaking on designing your first Power View report for SQL Lunch. Be sure to join me...
2012-07-11
1,134 reads
Baton Rouge SQLSaturday #150 & Tech Day .Net 1 track
August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. LSU has offered...
2012-07-10
2,977 reads
Book: Expert Performance Indexing for SQL Server 2012
After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...
2012-07-10
1,875 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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