Presenting Biml and Team-based Development at PASSDC and BSSUG
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
537 reads
I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...
2014-04-03
537 reads
If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...
2014-02-05
1,316 reads
We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...
2014-01-21
574 reads
What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT a.[BusinessEntityID] , b.[FirstName] , b.[LastName]FROM[HumanResources].[Employee] a INNER JOIN [Person].[Person] b ON...
2013-03-05
772 reads
What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...
2013-03-05
888 reads
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
832 reads
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
466 reads
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,478 reads
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
782 reads
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
759 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers