PASS Virtual Chapter Events : October 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-10-02
806 reads
Blog Posts
Recovering the tail end of the transaction log
Knowing a great deal about backup and recovery is key to any DBA’s career. Most of us fully understand the...
2013-10-02
1,297 reads
Setting Up a Domain Controller with PowerShell
Quickly setting up a domain controller is a vital step in creating a good demo environment. This post will walk...
2013-10-02
2,037 reads
SharePoint Reporting Services Content Types Missing
Being able to manage the content types in your SharePoint libraries is key to creating a useful portal. Among the...
2013-10-02
2,824 reads
Social Engineering: How to prevent unauthorized access to SQL Server using SQL Logins
People are always concerned about Security when it comes to their data. I don’t blame them, I love keeping my...
2013-10-02
729 reads
SQL Server – How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL
The command prompt utility dtutil can be very handy when we want to quickly export an SSIS package from either file system...
2013-10-02
1,489 reads
Using A Non-correlated Subquery To Avoid DISTINCT
Nobody wants duplicate data. It’s messy, wastes space, and looks really bad on a report – I get that. What I...
2013-10-02
1,328 reads
Why I am not an MVP
On October 1st the emails went out notifying existing MVP’s in the Oct cycle if they were fortunate enough to...
2013-10-02
765 reads
Awarded Microsoft MVP
Today I’m extremely excited, honored and humbled to announce that I have been recognized as a Microsoft MVP for first...
2013-10-01
700 reads
Detaching a database
In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL...
2013-10-01 (first published: 2013-09-26)
1,663 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
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...
Forums
advice on ssrs version control
Hi we're a bit behind on versioning ssrs. I think we have over 1600...
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