T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
T-SQL Tuesday #31 – Bulk-Logged Recovery Model and Point-in-time Restore
This blog entry is participating in T-SQL Tuesday #31, hosted this month...
2012-06-12
1,902 reads
Blog Posts
T-SQL Tuesday #31 – Logging
This month’s T-SQL Tuesday is hosted by Aaron Nelson (@SQLvariant | Blog). The topic is about logging. Many will talk about...
2012-06-12
1,043 reads
T-SQL Tuesday #31 – Logging
It’s T-SQL Tuesday time again, and this month Aaron Nelson (blog | @sqlvariant) is hosting. The topic is logging, and if...
2012-06-12
1,643 reads
Using PowerPivot to Monitor Reporting Services
PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you...
2012-06-12
1,531 reads
Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...
2012-06-11 (first published: 2012-06-05)
5,375 reads
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,475 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,061 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...
2012-06-11
53 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
Slipping in a Break
I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks...
2012-06-11
858 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