SQL Server Quickies – a new way to learn about SQL Server
We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...
2012-08-01
496 reads
Blog Posts
SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure
In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...
2012-08-01
804 reads
Two New Cumulative Updates for SQL Server 2008
On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server...
2012-08-01
952 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,732 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,893 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,907 reads
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,678 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,684 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,084 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,732 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers