Why you should know how to script as well as use the GUI
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out...
2013-10-14
1,015 reads
Blog Posts
Colorado SQL Events : October 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2013-10-13
450 reads
Colorado SQL Events : October 2013
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring...
2013-10-13
342 reads
Notes from SQLSaturday #227 in Charleston
My first time in Charleston! Quick notes:
Made the drive with the family in 7 hours, not bad, and easily the...
2013-10-13
561 reads
SQL Server Partitioning: Getting Started
Partitioning is a feature that has been around since SQL Server 2005. It allows for users to split a table...
2013-10-12
2,673 reads
Carolina Whistle Stops
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the Carolinas. The first stop is coming up in just...
2013-10-11
9 reads
Carolina Whistle Stops
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the...
2013-10-11
665 reads
I’m 40 and I’ve Had Enough
I’m not old, but I did turn 40 today. If you ask my kids, they are likely to say that...
2013-10-11
812 reads
If you buy a Hyundai, don't expect BMW results
This sort of ties in to my last post on denying reality.
Managing expectations is the most important thing to success...
2013-10-11
698 reads
PASS Attack!
It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013...
2013-10-11
717 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
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
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
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