MS12-070 - Should I patch more than Reporting Services?
If you're dealing with a version of SQL Server greater than SQL Server 2000, at this point I'm going to...
2012-10-11
1,980 reads
Databases – Infrastructure – Security
Slides and Scripts from Idera Auditing SQL Server presentation
I had a few folks ask me for the slides and SQL scripts from the Auditing SQL Server webinar I...
2012-10-10
1,564 reads
Microsoft Security Bulletin MS12-070 for SSRS
Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...
2012-10-15 (first published: 2012-10-09)
4,293 reads
Kathi Kellenberger speaking at Midlands PASS
On October 17th, Midlands PASS will welcome Kathi Kellenberger to speak on T-SQL 2012. Here's what her talk will be...
2012-10-05
1,087 reads
Webcast on SQL Server Auditing on October 9th
Idera will be re-broadcasting that I recorded earlier in the year on meeting audits with SQL Server. It's scheduled for...
2012-10-04
1,059 reads
Participate in the PASS Election Process
Once again it is time for the Professional Association for SQL Server (PASS) Board of Directors election. This year there...
2012-09-26
1,064 reads
The Reason I Won't Be at the PASS Summit This Year
We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...
2012-09-24
1,478 reads
PASS ProfDev VC presentation recording available
Back on August 15th I did a webinar for the PASS Professional Development virtual chapter on my talk Being the...
2012-09-10
1,131 reads
An important query to remember
This is based on a post with respect to where our focus and efforts should be that I wrote at...
2012-08-30
1,863 reads
Don't Disconnect Your Common Sense
This falls in line with a previous post about common sense in IT.
I was having lunch with a co-worker,...
2012-08-23
1,746 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Shelf Life Testing Laboratory | FARE LABS Pvt. Ltd.
Fare Labs' shelf life testing facility has been accredited by the NABL. The best...
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers