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.
Hello, all. We use SQL Server 2008r2 and a database failed to start. I want to restore the database but i need a help, how to do this. Thanks in advance ...
While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with great new advance features and stable SQL Server(just ...
I have procedure running in SQL 2008 with TABLOCKX and HOLDLOCK with READ uncommitted isolation level. While running the proc sometimes transaction ...
It can be a challenge to keep up with the rapidly evolving SQL Server platform. Andy Warren has a few ideas today.
This article shows how you can create a dynamic report in SQL Server Reporting Services (SSRS), walking you through the steps needed to create a dynamically-grouped ...
SQL Saturday #440 is coming to Pittsburgh on October 3, 2015. Now is the time to submit if you'd like to speak at the event.
Building (or rebuilding) a Columnstore index can be a resource intensive operation. In this article, ...
i have a canadian co that i have programmers collecting information from website and storing into sql table.
it should be xx BSD QuÃ©bec instead Canon ...
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.