Here at Database Weekly, 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. Here, we have an assortment of the latest articles from selected sources.

At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.

Latest Articles


SQLServerCentral - Questions
Tables has the following columns: dept_name, varchar last_name, varchar first_name, varchar salary, money I need to run a query to list top 5 paid employees ...
23:24 27-Aug-2015
DatabaseWeekly - Newsletter
Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
On Azure Virtual Machines, you are provided with drive "D:" drive to store temporary data. Noa Brodezky describes an issue encountered moving tempdb ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not, it seems, Power BI 2.0 the ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
Perhaps you've come across a great cache of publicly available SQL scripts that would be very useful in monitoring your databases, and these scripts are ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
Trustify is recording searches and spurring inquiries for paid investigations - but other aspects such ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
It isn't just the attraction of the huge range of statistical analyses afforded by R that attracts data people to R. The language has also developed a ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
How to upload files without scripts. While this will work for our demo and learning purposes, I would encourage you to use scripting to handle production ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
Performing a transaction log backup every 15 minutes has its advantages. But it also has disadvantages. Ever tried to restore hundreds of transaction ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often brings ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
During the development of SQL Prompt 7, we overhauled the snippet manager to make it more powerful and customizable. The snippet manager documentation ...
17:48 27-Aug-2015
DatabaseWeekly - Newsletter
I know that one of the things I am frequently asked is to figure out what data type belongs with which column. Furthermore, does this same column exist ...
17:48 27-Aug-2015
SQLServerCentral - Questions
Hello Techie, may any one please help me how to solve this puzzle Please. /* Rules The resultset should appear only when fulfill ...
17:13 27-Aug-2015
DatabaseWeekly - Newsletter
Beginning with SQL Server 2016 you will have the ability to store portions of a database in the cloud. This new ability is known as Stretch Database and ...
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
The new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance.
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
From Turning on AutoShrink to being rude to all developers.
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
Before our consulting engagements start, we send clients a couple of queries to run. One of them outputs a list of databases, and the last backup date ...
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
Paul Randal demonstrates some cases of skewed parallelism; a seeming explosion in CXPACKET waits occurring because the distribution of work between the ...
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
Grant Fritchey provides a simple alternative to nuking the cache on your server (DBCC FREEPROCCACHE) just because you wanted to take out a single terrorist ...
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
The advices Chris Webb gives is always the same: Reduce the number of rows that your query returns!
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
last month Microsoft released the new Power BI which included a new self-service BI application called Power BI Desktop. Dan English use it to build a ...
16:48 27-Aug-2015
DatabaseWeekly - Newsletter
At first this seems to be quite an easy question, but when you look into the details of the answer it can be surprising. There are 2 different ways to ...
16:48 27-Aug-2015
SQLServerCentral - Blogs
So apparently the COO of Facebook is trying to make the word “wogrammer” – a woman programmer – a thing.  (Thanks to Vicky Harp ...
16:22 27-Aug-2015
SQLServerCentral - Blogs
I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I've been doing testing work with tSQLt and wanted to run ...
15:25 27-Aug-2015
SQLServerCentral - Blogs
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. ...
14:35 27-Aug-2015
SQLServerCentral - Blogs
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting ...
14:30 27-Aug-2015
SQLServerCentral - Blogs
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared to the relational databases ...
14:00 27-Aug-2015
SQLServerCentral - Blogs
One of the big goals for SQLSaturday was for it to be a membership drive. It’s worked hugely well in some ways; we’ve added tremendously to ...
13:24 27-Aug-2015
SQLServerCentral - Questions
Hi I was assigned a task where in 6 parameter will be passed to sp and according to those para I have to define 3 slots for e.g. Para 1 = 20 , Para ...
12:48 27-Aug-2015
SQLServerCentral - Questions
I'm looking for the fastest way of testing two databases for data equality. The use case is automated testing where I take a database, perform an operation ...
12:41 27-Aug-2015
SQLServerCentral - Blogs
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event has come and gone, but this time it was different. ...
12:39 27-Aug-2015
SQLServerCentral - Questions
i have a table with 200GB size and 25642900000 rows. when i run dbcc check table it took 20 hours. There are no computed columns, no sparse columns on ...
12:06 27-Aug-2015
SQLServerCentral - Blogs
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel file in BIDS/SSDT - which is a 32-bit ...
11:00 27-Aug-2015
SQLServerCentral - Questions
I have seen a lot of forums where this question is asked but they all seem to be older. We are looking to beef up our reporting capabilities and I am ...
09:41 27-Aug-2015
SQLServerCentral - Questions
Having issues with this code? Can someone help me? I cannot connect to my SQL once I fill out the email address my information is not recorded into my ...
09:41 27-Aug-2015
SQLServerCentral - Questions
select GL, sum(TotalFuel) as "tf" from fueltable1 where [TransDate] > '3/1/2015 12:00:00 AM' and [TransDate] < '4/1/2015="" 12:00:00="" am'="" group="">
09:41 27-Aug-2015
SQLServerCentral - Questions
If my company upgrades from SQL 2003 to SQL 2012, will we have any issues with our Access 2003 as the front end to SQL 2012?
09:41 27-Aug-2015
SQLServerCentral - Questions
Hi, Currently I'm using SQL sever 2012 enterprise edition. I have configured a long running query alert. My SQL server is in **alwayson availability ...
09:41 27-Aug-2015
SQLServerCentral - Questions
Hello, i am using SQL Server 2012, recently i was facing the performance issue with one of the report in application. i got a question: is this related ...
07:30 27-Aug-2015