Run For the PASS Board
When the word comes around for elections to the PASS Board, are you one of those people who, even in...
2016-08-22
419 reads
The Scary DBA
Updates to Azure Data Platform Learning Resources
I’m acting as the curator to a list of Azure Data Platform Learning Resources. It’s speakers and teachers, blogs, articles...
2016-08-17
510 reads
Query Store, Force Plan and Dropped Objects
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL...
2016-08-23 (first published: 2016-08-15)
1,804 reads
Azure SQL Database For Your First Database
This is post 8 supporting Tim Ford’s (b|t) initiative on #iwanttohelp, #entrylevel. Read about it here.
In post #6, I talked about...
2016-08-15 (first published: 2016-08-09)
1,462 reads
There Is No Difference Between Table Variables, Temporary Tables and Common Table Expressions
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,387 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,622 reads
Common Table Expression, Just a Name
The Common Table Expression (CTE) is a great tool in T-SQL. The CTE provides a mechanism to define a query that...
2016-07-21 (first published: 2016-07-18)
3,601 reads
Same Query, Different Servers, Different Performance. Now What?
Based on the number of times I see this question on forums, it must be occurring all the time. You...
2016-07-19 (first published: 2016-07-11)
2,418 reads
Carpenters vs. DBAs
Let’s get the caveat out of the way up front, I work for a tool vendor.
If you look around at...
2016-07-05
1,233 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,822 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers