E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
Investigating the new Spatial Types in SQL Server 2008 - Part 2
This is the second article in the series on the new spatial data types in SQL Server 2008
Using Script Component as a Transformation - SQL School Video
Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.
Escaping In Expressions
The expressions language in Integration Services is a C style syntax, so you may need to escape certain characters.
Using Partitioned Tables with Multiple Filegroups for High Availability
Let us look at another means to increase the availability of your highly critical databases. We will extend the concept of filegroups as highlighted in a previous tip on Disaster Recovery Procedures in SQL Server 2005 Part 2 (Isolating Critical Objects) wherein we can use filegroups to isolate and store a critical object.
Investigating the new Spatial Types in SQL Server 2008 - Part 1
This article introduces us to the new Spatial Data Types in SQL Server 2008
Trust But Verify
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
Easily Access Remote Data Using SQL Server Views
Getting to the data you need is always a challenge. Views can provide a "no muss, no fuss" way to retrieve the data you need—whether it's in the current database or another.
E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
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