In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

Today’s README file explains how to create connection strings to SQL Server databases using Visual Studio’s built-in tools. To provide an example using real source, I created a simple Winforms ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

Let’s start by admitting that the title of this article is a tease. It’s a valid question and one that thinking people ask all the time. But in truth it’s not the first question you should be asking.

Write-Host "Backup in Progress" $QueryStatement = "SELECT * FROM settings where setting_name='backup_path'" $Query = ...

Back in 2016, when Microsoft announced that SQL Server would soon run on Linux, the news came as a major surprise to users and pundits alike. Over the course of the last year, Microsoft’s support for ...

Microsoft PM Carlos Robles previews his Live! 360 Orlando session on how recent updates to the MSSQL extension—like GitHub ...

Microsoft this week announced that SQL Server 2016 database system will be landing on Linux. "This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...