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
Hello All Could you please help me out with the below requirement for displaying Countries and States in the report I have two Data sets one for Countries ...
02:45 04-Jul-2015
SQLServerCentral - Questions
I created a dataflow task which has a source oledb connection to Oracle and a destination oledb to SQL ...
18:16 03-Jul-2015
SQLServerCentral - Questions
Hi Folks Namaste!! Curios to know what happens when extended support for sql 2005 ends from clients point of view. We are using sql 2005 as back end ...
15:05 03-Jul-2015
DatabaseWeekly - Newsletter
Microsoft has finally created tables outlining what the different versions of the operating system are going to feature.
12:47 03-Jul-2015
DatabaseWeekly - Newsletter
Disappearing or renamed columns in your data source can cause all kinds of problems when you're importing data using Power Query: errors when you try ...
12:47 03-Jul-2015
SQLServerCentral - Blogs
Reading Time: 2 minutes The community makes it all happen! In WOxPod!, episode # 009 -... The post 010 – Ayman El-Ghazali appeared first on WaterOx ...
12:30 03-Jul-2015
SQLServerCentral - Blogs
With my travel schedule, I don’t always get out to events where I can see a community speaker. Sometimes, I just see pros. That’s the case ...
11:55 03-Jul-2015
DatabaseWeekly - Newsletter
At first glance, SQL Server's transactional replication seems like it's useful for moving data around in all sorts of situations: it works in Standard ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
"We're sorry for the inconvenience, but both your privacy and security are very important to us"! Oh ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
A Primary Key constraint and a Clustered Index is not really the same in SQL Server. By default SQL Server enforces the Primary Key constraint with a ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
You can get some pretty dramatic gains from indexes that cover columns on which you're performing aggregations.
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
I had cause today to use the Unpivot transformation in SSIS. My source database was still in 2000 compatibility mode, don't laugh, so I couldn't use the ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
Temporal Tables are a very cool new feature that takes something that used to be very painful (capturing history of changes to a table, allowing the user ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
Don Castelino troubleshoots a failed attempt to migrate the ReportServer database from SQL 2008 R2 instance to SQL 2014.
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
How can you edit row history in a temporal table? Well, the answer is simple, but the process isn't exactly simple. Basically, you have to turn off system ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
FORMAT() looks convenient, but it's expensive (oh and that AS VARCHAR thing is bad too). If you're doing this onesy-twosy and for small resultsets, I ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
No no, I didn't say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
The fastest way, if your hosted on SQL Server RDS, is to use parameter groups.
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
In this post, I'll help you get started with the really interesting DocumentDB stuff, namely - programming with DocumentDB in Microsoft Visual Studio ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
A flexible new distributed query capability is now available in preview in Azure SQL Database. Elastic database query allows tools and applications to ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
One of the most useful new additions to DAX in Excel 2016 and the Power BI Designer is the DateDiff() function.
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
Stretch Database lets you archive your historical data transparently and securely. In SQL Server 2016 Community Technology Preview 2 (CTP2), Stretch Database ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
Just released: the Community Technology Preview (CTP) of the Microsoft JDBC 4.2 Driver for SQL Server! The driver provides robust data access to Microsoft ...
11:47 03-Jul-2015
DatabaseWeekly - Newsletter
Growing up as a young boy, my elementary teachers always warned me about the perils of putting stuff in master. But what's the real deal? Why is this ...
11:47 03-Jul-2015
Simple-Talk - Blogs
Recently, I’ve been getting more and more engrossed in SQL Server Execution plans for various reasons, including editing the forthcoming third edition ...
09:52 03-Jul-2015
Simple-Talk - Blogs
We all feel groundless sometimes, but this fellow more than most. What caused his current woes? The funniest answer wins a $50 Amazon voucher.
09:50 03-Jul-2015
SQLServerCentral - Questions
Hi all, we are migrating cache database into SQL server 2012 database,created ODBC connection ...
09:50 03-Jul-2015
SQLServerCentral - Blogs
August and September are going to be some busy weeks! In those two months I will be speaking on three SQLSaturday events: SQLSaturday #414 Oslo – ...
07:24 03-Jul-2015
SQLServerCentral - Blogs
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or in other words, system-versioned ...
06:39 03-Jul-2015
SQLServerCentral - Blogs
Although generally I prefer to create custom interfaces for my databases using fully developed programming languages like Python or C#. I prefer to have ...
01:10 03-Jul-2015
SQLServerCentral - Editorials
We're halfway through the 2015 year and Steve Jones has a few thoughts for you this holiday weekend.
23:00 02-Jul-2015
SQLServerCentral - Main Articles
SQL Server Performance Dashboard comprises a set of custom reports that give you nitty gritty details about the performance of your SQL Server instance. ...
23:00 02-Jul-2015
SQLServerCentral - Main Articles
Cambridge, UK, 2 July 2015 - Redgate, the SQL Server and .NET software company, returns to London and ...
23:00 02-Jul-2015
SQLServerCentral - Questions
Declare @XS1VidGoal int, @XS2VidGoal int, @XS1HSDGoal int, @XS2HSDGoal int, @XS1CDVGoal int, @XS2CDVGoal int, @XS1XHGoal ...
18:18 02-Jul-2015
SQLServerCentral - Blogs
Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I never once gave a presentation of my own.  Of course ...
17:55 02-Jul-2015
SQLServerCentral - Blogs
First came the in-person roadtrip. That Kline family won’t be nearly as good at this as us Griswolds! Two weeks riding the highways from¬†Nashville, ...
17:53 02-Jul-2015
SQLServerCentral - Questions
I have an application and backend is SQL Server in Local Server and in Cloud Server. Now I am using one application and I want to transfer all the data ...
16:28 02-Jul-2015
SQLServerCentral - Blogs
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. How many of you can define ...
15:39 02-Jul-2015