Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.

Sign up to our newsletter now, to keep up to date with all the latest news.

Latest Database Weekly Newsletter Articles


Cumulative Update #4 for SQL Server 2012 SP2
Dear Customers, The 4th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Support site. read more...

Catching Money Launderers with Big Data
by Angela Guess Thor Olavsrud of CIO.com reports, “For the past decade, governments around the world have established international anti-money laundering (AML) and counter-terrorist financing efforts in an effort to shut down the cross-border flow of ... read more...

Automating web hosting creation in Azure with PowerShell
Here’s your situation: you’ve got a heap of websites on traditional hosting models. Shared tenancies on single logical machines, dedicated infrastructure or even worse, not really any idea because you just keep paying that $5 per month and stuff works. read more...

Upgraded SSD
I was going to call this an upgraded HDD, but that’s not right. Technically it’s a drive update, but really it’s an SSD upgrade. My new Portege Z30 came with a 128GB drive. I could have had Toshiba upgrade it, but it was more expensive than the deal ... read more...

Collation Conflicts
I have recently seen some “bad plans” being generated by the optimiser and from investigation, the cause came down to the fact that the collation of the database where the queries were running was different to the tempdb collation. Consider this situation, ... read more...

SQL Script to find the list of all the jobs failed yesterday
One of the important task of any DBA is to find out all the jobs which are failed yesterday. Below SQL Script can be used to find out all the jobs which are failed yesterday.SELECT DISTINCTCAST(CONVERT(datetime,CAST(run_date AS char(8)),101) AS char(11)) ... read more...

Constraint names, Say NO to the default
Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it makes no difference in terms of how things run but it does make it a bit of a pain when you need to code with it. Say dropping ... read more...

Statistics Parsing
Never really enjoyed reading through the statistics IO results, as it makes it hard to easily guage total impact when you have a long list of tables. A friend referred me to: http://www.statisticsparser.com/ This site is great! However, I really don't ... read more...

Exam Prep 70-463: Data Flow Destination Adapters
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly Changing ... read more...

SQL- Querying XML attributes from XML Column
Read XML column attributes in to two columns DimType and Dimvalue from the below example read more...

Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to download the free Minion Reindex tool. read more...

Allocation Order Scans
When an execution plan includes a scan of a b-tree index structure, the storage engine may be able to choose between two physical access strategies when the plan is executed: Follow the index b-tree structure; or, locate pages using internal page allocation ... read more...

Administering SSIS: Security-related SSIS Questions
I credit my friend and brother, Chris Yates ( Blog | @YatesSQL ), for inspiring me to write this post with his (excellent) post: Reports in SSIS . If I had a nickel for each time I’ve been asked, “What permissions are required for SSIS?” I would have ... read more...

Dynamic ABC Classification in DAX #powerpivot #dax #ssas #tabular
Less than one year ago I published a pattern about ABC Classification in DAX. Such a pattern was static, so an item (e.g. customer, product) is classified statically when you process a Power Pivot or Tabular model, so filters and slicers querying data ... read more...

A Custom Execution Method – Level 19 of the Stairway to Integration Services!
A Custom Execution Method – Level 19 of the Stairway to Integration Services is live at the Stairway to Integration Services site at SQL Server Central ! Enjoy! :{>...(read more) read more...

A Start with Automating Database Configuration Management
For a number of reasons, it pays to have the up-to-date source of all the databases and servers that you're responsible for in a central archive, in version control, and this is a job that is best automated. If you enlist the help of SQL Compare Pro, ... read more...

Designing Indexed Views for OLTP Workloads
When I look at indexed views defined on OLTP databases, I’m encouraged when their join diagrams resemble snowflake schemas. When you create an indexed view, SQL Server will enforce a number of restrictions. These restrictions ensure that your views ... read more...

How I tune SQL Server queries
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.) I’m a lazy person. I just want to do as little work as ... read more...

Azure Blob Storage Part 5: Blob Storage REST API
This article is one in a series of articles on the Azure Blob Storage service. If you would like to jump to other articles in these series: Part One: Introduction Part Two: Getting Started Part Three: Using the Storage Client Library Part Four: Uploading ... read more...

SQL SERVER – How to Find Weak Passwords Using T-SQL?
Recently one of my blog reader emailed me below question. Hi Pinal, Need your urgent help. In recent past, we have been attacked by the hacker who was able to get in to our SQL Server via sysadmin account and made big damage to our data. To make sure ... read more...