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.
PowerShell Direct lets you breach the boundary between hypervisor host and guest virtual machine in a secure way to issue PowerShell cmdlets and run scripts ...
A couple of quick "how to" scenarios on using SSMS to look at Query Store data on Azure SQL Database V12.
Booby-trapped MMS messages and websites exploit flaw in heart of Android.
One of the most compelling features in PowerShell is how easy it is to extend it. You're not limited to whatever a cmdlet writes to the pipeline. You ...
Your very own personal assistant, a better browser... and something called the Start menu.
The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers ...
As with any technology, the "mileage" you get from NoSQL varies depending on your team's expertise and culture. As Uber's recent switch from PostgreSQL ...
Pinal Dave describes how to write directly to sparse column sets.
Like so much of IT, database security requirements largely depend on the situation and environment. Needs may be completely different from one shop to ...
A script to save to an Excel file the database file properties for all databases for all the databases that are in the SQL Server instance.
The cloud is ready for SQL Server enterprise-grade workloads. This is not my opinion but a simple fact that comes from helping multiple clients in different ...
The question was "What is the significance of NULL in SQL?" and most of the existing answers went on about citing C.J. Date or Tony Hoare and unanimously ...
How train companies derive insights and value from the data of trains, rail infrastructure, and operations. In essence, this means automatically gathering ...
Windows PowerShell console process name is PowerShell. No problem. Except that I often have multiple instances of Windows PowerShell running, and quite ...
Don't tell me that you didn't see it coming: at some point, Developers end up being put to hell by a DBA!
I don't want to enter the DBA/Developer wars, ...
This is a first article in a series of articles about real life database and IT infrastructure migration ...
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.
According to a new survey, Python's data science training wheels increasingly lead to the R language
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 ...