The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of working with SQL Server. The most suitable approach to accessing SQL Server depends on the sort of task you need to produce a script for. Laerte Junior aims at a simple guide to the most common approaches and when to use them.
2016-06-14
3,826 reads
IronPython is a Python implementation build on .NET. This article shows how you can use IronPython to access SQL Server Management Objects.
2016-06-13
3,776 reads
Automated configuration management is simpler with Desired State Configuration (DSC) and Push mode, but what is the best way to use DSC to automate deployments on your machines? ‘Push’ mode or ‘Pull’ mode? How can you reduce configuration-drift over time? Nicolas Prigent describes the second DSC deployment mode: Pull mode.
2016-06-13
3,500 reads
Using the APPLY operator to reduce repetition and make queries DRYer.
2016-06-10 (first published: 2015-04-02)
22,786 reads
There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index.
2016-06-10
4,346 reads
Inside SQL is the Deep Dive conference for SQL Server professionals in London on June 14.
2016-06-09
3,538 reads
Aaron Bertrand rounds out his series on STRING_SPLIT() in SQL Server 2016 with additional tests comparing splitting techniques to TVPs.
2016-06-09
4,804 reads
2016-06-08
106 reads
What about database development? In most projects, developers aren’t focused on database development and for proper CI, the database version should keep neck to neck with the application builds.
2016-06-08
4,220 reads
Ahmad Yaseen takes a look at how to deal with an endpoint encryption compatibility error when using SQL Server's AlwaysOn Availability Group Wizard.
2016-06-08
2,497 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers