Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
2 reads
Jason Brimhall
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,260 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that...
2012-05-18
860 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that trend. I do have a good excuse for...
2012-05-18
2 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
849 reads
SQL 2012 has Launched
LAUNCH
If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it,...
2012-04-01
982 reads
SQL 2012 has Launched
LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched. With it, some really cool features are now available to...
2012-04-01
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then...
2012-03-26 (first published: 2012-03-20)
2,402 reads
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Forums
How to write this query?
Hi everyone I have two tables storing stock prices. Each table comes from a...
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers