Setting Up SQL Server: People Still Need Help
Erik points out a few things that SQL Server should offer to configure by default.
2018-08-24
4,779 reads
Additional Articles
Azure DevOps: Show Me the JSON!
Creating resources in Azure, while not difficult, can be time consuming if you use the manual steps. One way to automate the process is by using JSON templates to save time and enforce standards. In this article, Brian Flynn describes how to create JSON templates for deploying a network with virtual machines.
2018-08-23
3,050 reads
Granting View Definition Permission to a User or Role in SQL Server
In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
2018-08-22
3,287 reads
How to Resize tempdb
When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.
2018-08-21
4,154 reads
Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
2018-08-20
2,844 reads
How to Check Performance on a New SQL Server
Before you go live, test your backup and CHECKDB speeds.
2018-08-17
4,748 reads
Information Security in Practice
Along with the GDPR, regulations require that confidential data is protected and used properly. In this article, William Brewer discusses the ways that data manages to migrate around the organisation and the challenges found in protecting that data.
2018-08-16
3,193 reads
SQL Server Performance Tuning Scripts, Tips and Tricks
In this webcast, Tim Smith takes a look at various tips and tricks to assist you with performance tuning your SQL Server databases. Knowing how to find and resolve problems is key to improving performance, so join him to learn how to optimize your systems
2018-08-15
4,840 reads
How to Remove Transparent Data Encryption From a Database
There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. In this tip, Greg Larsen shows you how simple it is to remove Transparent Data Encryption.
2018-08-14
2,853 reads
Go Unit Tests: Tips from the Trenches
In this article, Michael Sorens describes unit testing for applications written in Go. While focused on Go, many of his recommendations and techniques can be applied to other languages as well.
2018-08-13
2,707 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
The 2026 Redgate Summit in New York City
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers