Idera ACE Program
On March 9th a tweet went out by David Fargo announcing the 2012 Idera ACE’s and my twitter handle was...
2012-03-14
607 reads
Tim Radney - Database Professional
Find the version of the Master DB from a backup
Try researching recovering the master database online and you will see countless references to having to have SQL at the...
2012-01-25 (first published: 2012-01-20)
3,011 reads
SQL Server Login Auditing
In recent months I have been asked to ensure we are auditing both successful and failed logins, not just failed...
2012-01-05 (first published: 2012-01-03)
2,870 reads
Increase SQL Server Error Log Files
Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance...
2012-01-04 (first published: 2011-12-30)
4,016 reads
RedGate SQL Index Manager BETA
I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL...
2011-12-29
2,548 reads
When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were...
2011-12-08
503 reads
First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed...
2011-12-08
540 reads
Summit Sessions Day Three
I started out day three after the keynote by attending Adam Machanic session on Query Tuning. I must say that...
2011-10-15
606 reads
Summit Sessions Day 2
Day two of sessions only had me attending three sessions. One of them was 3 hours. I started out after...
2011-10-15
602 reads
Final Summit Keynote – NoSQL = Not Only SQL
The keynote started out with Rob Farley and Buck Woody singing an awesome song about a slow running query. What...
2011-10-14
1,616 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers