DR planning article up at MSSQLTips!
My latest article is up at MSSQLTips.com:
Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
For more of...
2013-05-23
847 reads
Giving an SSIS security webinar with Andy Leonard
Andy Leonard (blog | twitter) and I are teaming up to do a security presentation on SSIS. It's scheduled for Wednesday, May...
2013-05-23
1,046 reads
Ad-hoc Reporting with SharePoint Recording and Q&A
I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If...
2013-05-23
1,246 reads
Speaking at SQL PASS Summit 2013
WOW! I was selected to present at the SQL PASS Summit 2013 in Charlotte, NC. in October! All I can...
2013-05-23
567 reads
The Bicentennial SQLSaturday–#200 Philadelphia
When Andy Warren (b | t | Li)started SQL Saturday with #1 in Orlando, we weren’t sure it would succeed. After a...
2013-05-22
907 reads
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response...
2013-05-22
1,550 reads
SQL Server Transactions and Locking (Part 1)
In many situations, data modification requires several steps. For example, you may need to change the values ??in two separate...
2013-05-22
612 reads
Designing and Implementing Online Analytical Processing (OLAP) Architecture (Part 1)
The well-designed online analytical processing (OLAP) solution is fundamental to organizations analysis capabilities. That is why, when designing the OLAP...
2013-05-22
893 reads
SQL Server index related dynamic management views and functions (Part 3)
With the release of SQL Server 2005 and later releases, Microsoft introduced set of new dynamic management view and function...
2013-05-22
590 reads
Presenting 2 sessions at SQLPASS
I’m truly honored to be chosen to speak at PASS Summit 2013. The honor is compounded as I have been...
2013-05-22
693 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