Planning for ETL solution
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL...
2012-12-02
707 reads
Blog Posts
Why SQL Server security matters: A case study
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
821 reads
XML Support and SQL Server
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
637 reads
SQL Server Consulting Blog–Saturday Stats 1st Dec 2012
This post is little experiment I’m trying out this weekend. The SQL Server Consulting blog has been up and running...
2012-12-01
881 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL...
2012-11-30
19 reads
Creating an empty table from a SELECT statement
I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W....
2012-11-30 (first published: 2012-11-26)
4,618 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,179 reads
Lost in Translation – Deprecated System Tables – sysprotects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-30
1,817 reads
New Book: Knight’s SSIS 2012 24-Hour Trainer
I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services...
2012-11-30
3,331 reads
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data...
2012-11-30
2,385 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers