Security Questions: Migrate Logins Between Servers
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-06-13
583 reads
Levels in IT consultancy
The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...
2013-06-13
1,057 reads
Book Review: Instant Creating Data Models with PowerPivot How-to
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
599 reads
Printing the Report Parameters on SSRS
I'm surprised there isn't an option in the Report Manager for allowing you to include on the print out of...
2013-06-17 (first published: 2013-06-13)
6,208 reads
Why should we upgrade off of SQL Server 2000?
A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted...
2013-06-13
905 reads
Update Your Audit Queries for SQL Server
I was working with an auditor today who is working through a system with an external audit agency. The external...
2013-06-13
2,134 reads
Virtual SQL Playground Adventure: Introduction
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,486 reads
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...
2013-06-12
1,435 reads
Centralized SSIS solution to monitor failed SQL Server Agent Jobs across the enterprise
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
884 reads
SQL Server Transactions and Locking (Part 2)
Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...
2013-06-12
596 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers