The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established...
2013-03-05
1,473 reads
When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic...
2013-03-05 (first published: 2013-02-25)
5,073 reads
Hello and welcome to the third T-SQL Tuesday of 2013!
Over three years ago, Adam Machanic (Twitter) dreamed up the idea...
2013-03-05
655 reads
Data Explorer (download), which I first mentioned in my blog about PASS Summit 2011 (SQL Server 2012 and other PASS...
2013-03-05
1,983 reads
Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...
2013-03-05
557 reads
I was reading about the American Association of Woodturners annual symposium that will be held in Tampa this year (and...
2013-03-05
638 reads
Recently while changing some production security around on a new server I needed to modify the SQL Server Analysis Services...
2013-03-05
1,236 reads
I received my long-awaited Microsoft Surface Pro 128GB yesterday! The first thing I did was to promptly install SQL Server...
2013-03-05
4,468 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
895 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
783 reads
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Creating a Simple and Flexible...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers