Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text
I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats...
2012-11-12
1,713 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
19 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might be in a hole, stop digging. " That...
2012-11-12
17 reads
Summit 2012 is over, but not forgotten
What a whirlwind last week was. There were so many sessions to attend and only one of me. I needed...
2012-11-12
742 reads
T-SQL Window Functions on LessThanDot and at SQL Saturday 149
Reblogged from Data on Wheels - Steve Hughes: I recently completed a series of blog posts on www.lessthandot.com on T-SQL Window...
2012-11-12
625 reads
Surface Problems With Azure
I’ve been posting about the Surface over the last couple of weeks and I’ve tried really hard to be positive...
2012-11-12
998 reads
Rules of Holes #1: Stop Digging
You may have heard of the 'First Rule of Holes'. It goes something like this: " When you suspect you might...
2012-11-12
1,337 reads
November 2012 – Monthly SQL Server Checklist
Last week was the PASS Summit and there were a few cool announcements made. One in particular was the release...
2012-11-12
575 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,037 reads
Book Review: SQL Server 2012 Analysis Services The BISM Tabular Model
I will start off by saying, whenever I see the names Marco Russo, Alberto Ferrari and Chris Webb on a...
2012-11-12
1,898 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Alamat BCA KCP Sopo Del Telp:0821°7555°651
Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...
Alamat BCA KCP South Quarter Telp:0821-8200-203
Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...
Alamat BCA KCP Graha Paramita Telp:08218200233
Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers