SQL Server Training Events–November and December 2013
I’m in New York City this week delivering a SQL Server Virtualization and Consolidation 3 days course for Learning Tree....
2013-10-29
707 reads
Blog Posts
Startup Weekend Orlando
Startup Weekend comes to Orlando on Nov 22-24, 2013. I haven’t been (and not sure I will make this one)...
2013-10-29
756 reads
The times they are a-changin’
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
744 reads
The times they are a-changin’
This blog post will not be about Bob Dylan, but rather about some professional changes/challenges I’ve been up to lately.
The...
2013-10-29
500 reads
What’s In My Utility Belt? Issue #1
Welcome to the first issue of what I hope will become a monthly series called “What’s In My Utility Belt?”....
2013-10-29
561 reads
Change in SQL 2012 SSMS grid output behavior
It’s one of those things that always aggravated me but not really enough to complain about. When you run a...
2013-10-28
705 reads
is count(1) faster than count(*)?
Recently I saw a post regarding the count(1) and count(*)
http://www.sqlservercentral.com/articles/T-SQL/102474/
the post said "You know that doing COUNT(*) on a table with...
2013-10-28 (first published: 2013-10-20)
5,793 reads
Last Weeks Top “Reading” Links #55
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-28
1,109 reads
Notes from the Oct 23, 2013 oPASS Meeting
I drove up to Sanford after work on Thursday for the oPASS meeting to see Mark Kromer present Big Data...
2013-10-28
773 reads
Only one month left! Register for the SQL Server Live! Conference in Orlando Through TheSQLPro.com and Receive a $500 Discount
The SQL Server Live! Conference in Orlando is between November 18-22, 2013. There is a discount code provided for those...
2013-10-28
714 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers