How to change an Azure SQL Database Collation
In this tip we look at the steps you can follow to change the collation for an Azure SQL Database.
2018-07-23
3,184 reads
Additional Articles
2018-07-20
5,252 reads
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Power BI allows you to use parameters to make your reports dynamic. In this article, Robert Sheldon demonstrates how parameters can be used to substitute connection information, query filters, or even calculations within the query.
2018-07-19
3,727 reads
SQL Server Reporting Services Rest API
What functionality is available in the SQL Server Reporting Services REST API and how should you use it?
2018-07-18
3,886 reads
Using SQL Server's Default Trace to Identify Autogrow Events in tempdb
We all know that you should try to size tempdb appropriately, so it doesn’t need to autogrow shortly after starting up SQL Server. It isn’t always easy to do this. Therefore, when you first implement a new server and/or add new databases you should monitor the autogrowth events on tempdb. By monitoring the autogrowth events you can easily determine if you have sized tempdb appropriately.
2018-07-17
2,946 reads
T-SQL Window Functions and Performance
T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. In this article, Kathi Kellenberger explains what you need to know to get good performance when using these functions.
2018-07-16
4,197 reads
What to Do When SQL Server is Slow
Brent Ozar's session for the PASS DBA Fundamentals virtual chapter.
2018-07-13
6,099 reads
Principles of Data Protection
Protecting data in SQL Server is not as simple as setting a few properties. While there are great security features in SQL Server, such as Transparent Data Encryption, production data may end up in places throughout the organization. In this article, Brian Kelley talks about the best ways to secure data using the concept of least privilege.
2018-07-12
3,100 reads
Examples of using XQuery to update XML Data in SQL Server
What is the most efficient way to modify XML values? To allow for precise modification of XML nodes and values, the XQuery XML query language employs an extension known as the XML Data Modification Language (DML). The XML DML uses the XML modify() method, which makes use of three operational keyword sets: insert, replace value of, and delete. Seth Delconte takes a closer look.
2018-07-11
2,712 reads
Automatic Query Performance Tuning in SQL Server Database
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
2018-07-10
4,171 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I