Memory Limits in SQL Server 2016 SP1
Aaron Bertrand explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.
2017-01-02
3,926 reads
Additional Articles
How to read the SQL Server Database Transaction Log
Manvendra Singh takes a look at a SQL Server function that you can use to read the transaction log to see what entries are made for database transactions.
2016-12-30
4,902 reads
Getting Started with R Services in SQL Server 2016 – Part 1
SQL Server 2016 brings native support to advanced analytics in the database itself, using R Services. In this article, Arshad Ali explains what R is, what the on-premise advanced analytics options from Microsoft are, and shows how to get started using R Services with SQL Server 2016.
2016-12-29
4,325 reads
Importing Excel Data into Power BI Desktop
In any commercial setting, Excel Spreadsheets remain the preferred way of collecting and analysing data, and it makes sense that it should be easy to get the data into PowerBI so it can be made more generally available for sharing and further analysis. As well as the data, we'd probably need the other analysis components such as the Power Pivot tables, Power View visualizations, Power Query queries. It is all possible, and Robert Sheldon demonstrates how.
2016-12-28
2,896 reads
Reading, Writing, and Creating SQL Server Extended Properties
There is a great gulf between wanting to document your database properly with extended properties and actually doing it. Extended Properties have many uses but they aren't easy to use. Phil Factor is on a mission to make it easier for ordinary mortals to use extended properties as intended, to aid the database development process.
2016-12-27
3,765 reads
Spills SQL Server Doesn’t Warn You About
Table variables get a lot of bad press, and they deserve it. They are to query performance what the TSA is to air travel. No one’s sure what they’re doing, but they’ve been taking forever to do it.
2016-12-26
3,341 reads
Managing Packages Using Windows PowerShell
Windows hasn't had a package manager in the style of the Advanced Packaging Tool (APT) of Linux distributions. Apt-get is a great way of installing packages and other software. We have Chocolatey, of course which has a growing library of software and even allows you to automatically update software. Now PowerShell has an 'official' way of using any system, such as NuGet, Chocolatey, GitHub or PSget. It is definitely useful and likely to mature into an indispensable tool for Windows users. Nicolas explains wh.
2016-12-23
3,951 reads
Capacity Planning Using Performance Data
Erin Stellato discusses the types of performance data needed to help with capacity planning.
2016-12-22
6,527 reads
Disconnecting SQL Server connections after query execution
One way to improve SQL Server performance is to use as few resources as possible. In this post Rahul Mehta demonstrates how you can do this by disconnecting queries post-execution with a simple change in SSMS.
2016-12-21
5,620 reads
What is Azure SQL Data Warehouse?
Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. Built on our massively parallel processing (MPP) architecture, SQL Data Warehouse can handle your enterprise workload.
2016-12-21
3,192 reads
Blogs
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Writing Better Dynamic SQL
By SQLPals
Writing Better Dynamic SQL This updated and "sort" of a style...
Forums
SQL Server 2025 has arrived!
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers