My Visual Studio crashed and I didn't know why!
Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...
2014-01-31
1,328 reads
Starting to Use Powershell
I have to admit that before the Powershell Challenge, I wasn’t really looking forward to using Powershell for much of...
2014-01-30
1,783 reads
Security, Compliance, and SQL Server – Recording Now Available
If you missed it live you get a second chance! http://www.mssqltips.com/sql-server-video/284/security-compliance-and-sql-server-video/. Had about 300 attend and more questions than we...
2014-01-30
1,104 reads
Uninstalling SSMS on Server Breaks SQL Powershell
I reviewed my daily report and saw that some jobs failed on six instances overnight, the common factor being that...
2014-01-30
2,334 reads
Non-unique indexes that COULD be unique
In my last post I showed a query to identify non-unique indexes that should be unique.
You maybe have some other...
2014-01-30
1,012 reads
Final Day for Power BI Voting, Can I Have Your?
Today is the final day for the Power BI Contest voting and I could use your help to move on...
2014-01-30
1,334 reads
Your own personal space
Somewhere to relax, get away from it all (by all I mean pesky Developers wanting code deployed on a bleeding...
2014-01-30
1,031 reads
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2014-01-30
1,135 reads
It May Be Necessary Re-enable Service Broker After Baremetal Restore
After the restore of a database, or perhaps a bare-metal restore of a Windows server running SQL Server, unique IDs...
2014-01-30
1,157 reads
Database Project Versioning
SSDT 2010, 2012 with TFS integration brought about a couple of different options when you are looking to version your...
2014-01-30
2,115 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
Forums
Training the next generation
Comments posted to this topic are about the item Training the next generation
Reusing Customer Specific Order Filtering Logic with CROSS APPLY and an Inline TVF (Part 4)
Comments posted to this topic are about the item Reusing Customer Specific Order Filtering...
PostgreSQL psql Meta Commands: Databases
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Databases
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers