Security Questions: Difference between sysadmin and CONTROL SERVER Permission
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-05-27
866 reads
Looking for Buried Treasure in the Transaction Log
Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up...
2013-05-27
1,210 reads
Last Weeks Top “Reading” Links #34
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-05-27
542 reads
The 2013 SQL in the City Tour
Once again, Red Gate is planning on a tour of the US for the SQL in the City events. Last...
2013-05-27
860 reads
Bulk Insert Task SSIS – Path Specified Cannot be Found or File Does Not Exist
When using the Bulk insert task in SSIS, you might encounter an error stating that The File Does Not Exist...
2013-05-27
787 reads
Use Lookups the right Way
SSIS Lookup tasks are all too easy to abuse as they are easy to setup and not really think about...
2013-05-27
325 reads
Temporary Post Used For Theme Detection (6a375569-f9c1-4835-a7fb-fa1ba0b240e4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e621c360-788f-48aa-bd56-670930569ab5 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2013-05-25
781 reads
Have you configured Database Mail to utilize multiple SMTP Accounts ?
Lets start discussing about this subject by closely looking at the term Redundancy. What is redundancy all about ?
Wikipedia defines redundancy as “In engineering, redundancy is the...
2013-06-03 (first published: 2013-05-24)
2,308 reads
MSBI (SSAS, SSRS and SSIS) Training
Hi Guys,
Anyone interested in online training for MSBI (SSAS, SSRS and SSIS), please contact @ er.lokeshsharma08@gmail.com.
Features - Best material (practical and theoretical) for becoming familiar with...
2013-05-24
443 reads
SQL – SQL Server Script to Iterate and Pull Data from All SQL Instances – Database Backup
This Post is a continuation of my previous post. Many times, there is a difficulty in pulling the data to...
2013-05-24
1,104 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