Reliably Drop A Database With CLR Stored Procedure
After I read Greg Low’s post and my initial try, I kept on thinking that I need to come up...
2014-01-20
435 reads
Blog Posts
Schema-only Backups and Restores
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,548 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
313 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
156 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
970 reads
SQL Server 2014 – Buffer Pool Extension
Wanted: more RAM
In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to...
2014-01-20
1,386 reads
Time for a Quick Rant
This is an actual quote from what we can only assume is a functional human being:
The database is very big...
2014-01-20
703 reads
SQL Saturday Nashville Wrapup
What a terrific week! I’m have a great start to 2014! Yesterday and today I had the opportunity to present...
2014-01-19
546 reads
Gathering Business Intelligence Requirements
Questions to Ask when Gathering Business Intelligence Requirements
When starting any project requirements are the key to being successful. Business intelligence...
2014-01-18
1,015 reads
DBA: Guardian of the Data
I was asked recently by Idera to take a look at the things that could cost a DBA their job....
2014-01-17
1,176 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers