Password Resets
I read this piece from Troy Hunt, which is a long look at the password reset process for a web...
2012-07-31
1,685 reads
Creating a DDL Trigger
One of the most amazing features to an old SQL Server 4.2 guy was the addition of DDL triggers to...
2012-08-07 (first published: 2012-07-31)
2,785 reads
Bad business practices damage your company, KRG Technology
I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email...
2012-07-31
1,751 reads
Reading Excel into SSIS via OpenXML Scripting
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've discussed before. They boil down to one main reason:...
2012-07-31
1,776 reads
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,740 reads
Exporting Data Using BCP
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
10,755 reads
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It...
2012-07-31
1,911 reads
SCRIPT: Basic Information About Indexes
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,100 reads
Reading Excel into SSIS via OpenXML Scripting
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've...
2012-08-02 (first published: 2012-07-31)
4,803 reads
Improve DBA Operation Productivity – Part Two
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,904 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers