SQL Saturday #240 Curacao
QL Saturday is coming to Curacao, Netherlands Antilles for a free day of SQL Server training and Networking on August 17. There will also be a pre-conference session on Practical Self-Service BI with PowerPivot for Excel.
Changing SQLServerCentral - Initial Thoughts
We have been considering lots of changes at SQLServerCentral, but we would like to get comments and feedback from the community as we move forward. This is the start of an series looking at potential and current changes.
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
Using Microsoft Excel to Retrieve SSAS Tabular Data
Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS tabular data into Excel. This provides an easy way of manipulating, visualizing and analyzing the data without needing to know the details of SSAS and the tabular model.
The School Year
This Friday Steve Jones looks forward to the rest of the year. It's almost time for school and do you have plans? Should you be making some plans?
New SQL Monitor Custom Metric: Failed SQL Server logins
This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.
SQL Saturday #235 New York City, NY
Come to SQL Saturday New York on August 17 for a day of free SQL Server training and networking. Some of the speakers at this event include Chris Bell, Ben DeBow, Ashish Sharma, and Hilary Cotter
The Big Data DBA
Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards.
Schema-Owned Tables and Generated DROP Scripts (SQL Spackle)
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
Blogs
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...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
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...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
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