First Week As The DBA Whitepaper Published
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
835 reads
Blog Posts
Learn To Code
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
630 reads
SQL Server 2014 Backup to URL
I’m absolutely in love with the concept of being able to create a backup directly to a protected, off-site location....
2013-12-11
1,723 reads
SQL Server Installation Folder Setup Log and Command Line Install Information
The other morning I was commenting during our regular meetings amongst fellow DBAs on where to read up on installation...
2013-12-11
5,287 reads
TheSQLPro YouTube Channel
That’s right, it’s time to take this blog up a notch! Last week I posted a video about using Hyper-V...
2013-12-11
614 reads
Thoughts on December 2013 Power Query Updates
Just in time for Christmas the Microsoft product teams responsible for Power BI have a slew of amazing updates. The...
2013-12-11
922 reads
User Groups and Winners!: Day 3
Today's winner is! Aadhar Joshi!
Congratulations for winning a free month of PluralSight. I'm E-Mailing you the code right now.
We still...
2013-12-11
539 reads
Be a Brilliant DBA
John Sanson (b|t) recently asked a bunch of us, “If you could give a DBA just one piece of advice,...
2013-12-10
525 reads
Certification Updates for SQL Server 2014
Info from Microsoft on how the MCSA and MCSE certifications will be altered for SQL Server 2014:
In reviewing the SQL...
2013-12-10
5,420 reads
DBA JumpStart – A SQL Community Ebook for DBAs
If you could give a DBA just one piece of advice, what would it be? I asked 20 successful and experienced SQL Server professionals this exact question. You can...
2013-12-10
26 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