Using DDL triggers to audit events
Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
Overview of SSIS
SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package.
The Lighter Side - Life is like an analogy
Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.
The SQLServerCentral.com Party - 2008
Steve Jones talks a bit about the upcoming SQLServerCentral.com event at the 2008 PASS Summit and asks for some ideas.
Essential Steps for the Integrated Enterprise Data Warehouse, Part 2
This article describes what the dimension manager and fact provider do, and how to configure business intelligence tools to use the integrated EDW.
Modifying Microsoft Access Linked Tables from SQL Server
In a previous tip we saw how easy it was to link to SQL Server tables from Microsoft Access. As is the case with all systems, how does Access manage the changes? What happens when you modify the structure of the underlying SQL Server table? What happens to the SQL Server table if you delete the linked table in Access? We will look at each of these situations in this tip.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers