I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for...
2014-09-02
1,321 reads
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,477 reads
Today I received an email notifying me that I have been awarded the Microsoft “MVP” award. An excerpt from Microsoft’s...
2014-07-01
1,354 reads
I am super excited to announce that I have been selected to speak at the 2014 PASS Summit. This is...
2014-06-25
1,224 reads
Working with Microsoft SQL Server for many years I have spent a lot of time discussing the importance of the...
2014-06-11 (first published: 2014-06-10)
3,354 reads
A couple of years ago I put together a training session to demonstrate various types of backups and restores. The driving...
2014-05-19
1,285 reads
When I started with the SQL Community I was first encourage to start blogging which I started in Sept of...
2014-05-12
1,209 reads
My largest client recently purchased BMC Control-M to use as our enterprise scheduler. Since this product went live in our...
2014-04-14 (first published: 2014-04-04)
3,986 reads
File Group backups are great when working with very large databases (VLDB’s) that have been partitioned. Typically when I come...
2014-03-31
2,717 reads
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,100 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
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