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.
The SQL Server 2016 CTP 2.2 incremental release includes new capabilities for query store, stretch database, core engine, temporal, MDS, reporting services ...
Which indexes are the big space consumers within the specified table for the given database?
Klaus Aschenbrenner explains why Forced Parameterization is not always a good choice.
Scott Hanselman shows how to upgrade the Start menu after upgrading to Windows 10.
When a performance issue exists in SQL Server, it's ideal to troubleshoot the issue live, but in some cases, historical information can provide a smoking ...
With Always Encrypted sensitive data is transparently encrypted and decrypted within a client application by a client driver. SQL Server does not have ...
According to a new survey, Python's data science training wheels increasingly lead to the R language
An ETL process that inserted a few thousand rows every few minutes was taking 300 milliseconds, and suddenly the duration spiked to about 3 seconds. What ...
Mary Jo Foley's review of Windows 10 after using it for a week.
A key question about any data warehouse, often overlooked in the purchasing process, is how the data gets in and out. While performance is obviously critical, ...
The fastest way to compute a median uses the SQL Server 2012 OFFSET extension to the ORDER BY clause. Running a close second, the next fastest solution ...
This Curah is a collection of videos on the most important features of SQL Server 2016. Speakers are Engineers and Program Manager of the SQL Server Team! ...
You can use this set of guidelines, fork them or make your own - the key here is that you pick a style and stick to it.
Grant Fritchey sketches out some of his goals for a proposed Leadership Training Course.
This man has some fine, fine whiskers. But that’s not really why we’re here – we want you to tell us what’s happening in this ...
We’re on the lookout for the best .NET performance tips. The kind that can save hours of work and loads of worry. The kind that, while simple when ...
One of the underlying realities of working with SharePoint's client side object model (CSOM) is that you are not continuously connected to SharePoint. ...
As per the previous article, i have tried to create the understanding for Distributed Cache service : Understanding, Planning and Configuring ...
Ive installed sql server 2014 developer edition on my pc (windows 8) I included the complete management tools but I cant find the enterprise manager. ...
Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking ...
Originally appearing at ForITPros.com.
In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions ...
I am not able to dynamically configure the method name using Expressions in the Property of a WebService ...
SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems ...
I am faced with an issue where I need to make a backup of a database to a URL. Can you help me? I'm on Sql Server 2012. Thanks in advance.
In One Of the Group the question was asked that How to list all the Servers in which SQL is installed?
It is genuine query. There are many scenario ...
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little ...
In the past, working in .NET for non-Windows platforms has been dependent on third-party frameworks like Mono. Now, with VS2105 and DNX Microsoft have ...
An invitation to hack United's IT systems has resulted in vulnerabilities being found and hackers rewarded for disclosing the issues.
Detecting file differences on two different web servers using T-SQL.
The latest version of tSQLt is now available with some SQL Prompt snippets to help you get started.
Tim Smith looks at what to take into consideration before building a design to archive old data in SQL Server databases.
I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was ...
Hi SQL Gurus,
I can't seem to find the answer to this simple problem. I am trying to convert a datetime to a numeric(5,2). I only want the minutes converted.
I need to be able to add a hyphen '-' to the end of a date column based on certain criteria.
If field3 has more then one 'VISIT' value.
Based on account ...
Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I thought I’d ...
Hi all ,
I opened transaction in master package level like ' begin transaction ' in execute sql task for this i used project level connection and set ...
This year's PASS Summit will end on Oct 31, which is Halloween in the US. I'm sure lots of people will have some fun on Friday, though I also suspect ...
Originally appearing in my monthly column at Database Trends & Applications magazine.
In the first of this three-part series, I described some of ...