Dynamically Create Tables Based on an Access Table
Create and Load Sql Server Tables based on Dynamic Access Database
Testing
We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.
Exploring Query Plans in SQL
SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time. How can we benefit from this to find potential performance problems in execution plans?
Data Lakes
An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.
SQL Server PCI DSS Security Patching Checklist
PCI DSS has strict requirements about implementing security updates and using only applications which are supported by the vendors. How do you create a patching policy for SQL Servers?
Multiple Backup Files
This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.
Backing up your SQL Server to Amazon's Cloud in Three Easy Steps
John Grover explains how to set up Amazon S3 storage, install and configure the Amazon PowerShell module, and set up a Maintenance plan using SQL native backups and PowerShell.
Two Days Off
Verizon is taking their cloud service offline for maintenance for two days. Steve Jones doesn't think that sounds good.
Archiving Hierarchical, Deleted Transaction Using XML
When you delete a business transaction from the database, there are times when you might want to keep a record of the data for posterity. In this article, Dwain Camps looks at a tidy means of doing just that.
Test Your Situation
One of the important things is to be able to recover your environment. That doesn't mean you need to know everything about SQL Server and potential disasters, but you should know their affect on your situation.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers