SQL Server Events in the UK – April 2013
The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...
2013-04-04
752 reads
How I prepared myself for the MCSE certification
Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...
2013-04-04
18,505 reads
Ask the Expert Panel: NJ Special Event
Ever wanted to know all there is to know about SQL Server, and afraid to ask? Have questions about how...
2013-04-04
1,221 reads
Compression Backup with BUFFERCOUNT parameter
If you want to make you backup faster, you can try BUFFERCOUNT parameter with compression backup.
From Book Online description:
BUFFERCOUNT = { buffercount | @buffercount_variable...
2013-04-03
3,138 reads
Failing to Overreach
I’m not sure what put this phrase in my head, though I think in part it came from various posts...
2013-04-03
723 reads
Pragmatic Works' Master SSIS Workshop coming to NYC
Pragmatically
speaking, there’s no way you can learn all there is to know about Microsoft’s
native ETL tool, SQL Server Integration Services...
2013-04-03
2,118 reads
Quick tip: Using sp_server_diagnostics
In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...
2013-04-11 (first published: 2013-04-03)
4,084 reads
Tomorrow: NYC Metro SQL Server User Group Presents Paul Randal and Kimberly Trip
Well, they're baack in the City!Coming this Thursday April 4, 2013 to the Big Apple, hosted by the NYC
Metro SQL...
2013-04-03
944 reads
DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats
sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx
Returns aggregate performance statistics for cached query plans. The view...
2013-04-03
4,587 reads
Total Number Of Records In each Table
Quite often in our day today activity we need to check the count of records in each table of the...
2013-04-03
739 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