Protection Close To Home
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
581 reads
Articles
There is no excuse
I read Jack Corbett's blog entry,No Training Budget Still No Excuse, last week and thought it was excellent. In fact,...
2009-08-21
1,956 reads
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-20
4,229 reads
Database Mirroring Using T-SQL
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
2009-08-20
3,401 reads
Flat File Imports with SQL Server Integration Services 2008
A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.
2009-08-20
4,444 reads
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
438 reads
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
438 reads
Storing IPv4 Addresses for Performance
An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries
2009-08-19
9,256 reads
The 2009 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
2009-08-19
95 reads
How to create SQL Server virtual appliances for Hyper-V
Creating a private SQL Server VAP will reduce the time it takes to deploy additional SQL Server machines in your environment.
2009-08-19
3,498 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers