SSIS Alpha Splits using the CODEPOINT() Function
A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on...
2010-02-04
4,408 reads
Blog Posts
SSMS and Visual Studio Tip
Did you know that if you right-click on a tab in SSMS or Visual Studio you get the option to...
2010-02-04
562 reads
The Events that Brought Me Here
1st event: I am here because my father wanted to be reunited with his family. He also hoped that his...
2010-02-04
680 reads
Three Things That Got Me Here
Tim Mitchell (Blog | Twitter) and Jack Corbett (Blog | Twitter) both tagged me in the latest meme circulating through the SQL...
2010-02-04
558 reads
Troubleshooting and Optimising SQL 2008 Reporting Services Configuration for Microsoft Dynamics CRM 4.0
Recently we have been struggling with configuration and installation of SQL Server Reporting Services 2008 when there was a co-existing...
2010-02-04
4,165 reads
Am I working too much?
The other night I was tired, a few long days, early mornings with the kids, and slightly wired, but needing...
2010-02-03
289 reads
DBCC CHECKDB() on ResourceDB?
A few days ago I was answering a forum post about CHECKDB() and as part of the research I checked...
2010-02-03
1,487 reads
Knowing how to use ATTRIB
ATTRIB is one of those commands back from the days of DOS which most folks don't even realize it's there....
2010-02-03
2,201 reads
Questions About SQL Server Backups
SQL Server backups are a “funny” topic to talk about. If you are talking with experienced DBAs, the topic of...
2010-02-03
801 reads
SQLSaturday & PASS – More Details
Yesterday I posted the news that SQLSaturday is now owned by PASS, today I’d like to share a bit of...
2010-02-03
1,095 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers