Last Weeks Top “Reading” Links #28
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-04-15
489 reads
Event Notifications 101 – Intro to Event Notifications
Once upon a time, in a blog post far, far away, I started talking about auditing in SQL Server. And...
2013-04-15
654 reads
Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
946 reads
SQL Server – Import Data from Excel using T-SQL
To import data from an Excel file to SQL Server you can use SQL Server Import and Export Wizard. You...
2013-04-15
29,024 reads
DMV-7 : Find Queries waiting for memory ?……..sys.dm_exec_query_memory_grants
sys.dm_exec_query_memory_grants DMV (Dynamic Management View), described by BOL as follows : http://msdn.microsoft.com/en-IN/library/ms365393.aspx
Returns information about the queries that have acquired a memory...
2013-04-15
1,067 reads
Determining when statistics were last updated in SQL Server?
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,516 reads
PASS SQL Saturday in Chicago Presentation Slides
Thanks to everyone who attended my sessions “What exactly is Business Intelligence?” and “Building an Effective Data Warehouse Architecture” at the PASS SQL...
2013-04-15
762 reads
PASS Business Analytics Conference Presentation Slides
Thanks to everyone who attended my sessions “Overview of Microsoft Appliances” and “Building an Effective Data Warehouse Architecture” at the PASS Business Analytics...
2013-04-15
707 reads
Calculating the length of a string (Len vs DataLength)
This one is basic but still something that can catch you unawares if you aren’t careful. Most DBAs and developers...
2013-04-15
1,508 reads
On the move
Its been a fair few years since I started blogging on SQLBlogCasts and the time has now come to find...
2013-04-14
631 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
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers