Avoiding OR Conditions with Joins
Why OR conditions in join statements should be avoided and an example fix.
OR conditions and join statements – some things just...
2011-06-03
2,812 reads
Blog Posts
PerformancePoint 2010 source control
While there is no way to use a source control system such as Team Foundation Server (TFS) or Subversion with PerformancePoint...
2011-06-03
914 reads
Re-blog – May 27-June 2
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-06-03
499 reads
SQLSaturday #77 Pensacola Florida Event Preview
Sometimes, even if I’m not attending, some SQLSaturdays stand out to me, and catch my interest. I guess it’s a...
2011-06-03
1,008 reads
Use PowerShell to Add a Login to a Database Role in all Databases
Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to...
2011-06-03
6,177 reads
What is SSMS Addin
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
707 reads
Duplicate Identity Values?
Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable
CREATE...
2011-06-02
4,265 reads
June 2011 Version of SQL Server 2008 Diagnostic Queries
Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information...
2011-06-02
683 reads
Just Deserts
Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...
2011-06-02
605 reads
NEW: Microsoft SQL Server 2008 R2 Administration Cookbook
I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitterfor several years...
2011-06-02
2,237 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers