The right way to approach a legacy code base
Andrea Angella shares what he learned from attending Michael Feather's workshop on working effectively with legacy code.
2017-04-20
4,251 reads
Additional Articles
Working with the BigInt Type in Node and SQL Server
Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the JavaScript TDS library called 'Tedious'. 'Tedious' is a mature product but it is still possible to get things wrong in converting SQL Server datatypes such as BigInt to native Javascript data.
2017-04-19
3,491 reads
Moving from application automation to true DevOps by including the database
Tom Austin talks about the challenges that arise from trying to include the database in your DevOps process.
2017-04-18
3,224 reads
Scaling out SSRS on SQL Server Standard Edition
The ability to scale out SSRS, so that multiple report server instances can access a single report server database, is an Enterprise Edition-only feature. So when Rodney Landrum was tasked with implementing a scale-out solution, with failover, for SSRS on SQL Server Standard Edition, it required some creative thinking. This article describes his solution, its merits and drawbacks.
2017-04-18
3,892 reads
Performance Myths : Clustered vs. Non-Clustered Indexes
Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
2017-04-17
5,314 reads
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.
2017-04-14
2,268 reads
Harmful, Pervasive SQL Server Performance Myths
Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.
2017-04-13
4,686 reads
Automating database deployments to and from source control using SQL Compare and PowerShell
Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.
2017-04-12
4,185 reads
Changing SQL Server Collation After Installation
In some scenarios we can find different SQL Server collations between the server instance and its databases. Douglas P. Castilho explains a simple way to correct the collations in a few steps.
2017-04-11
3,262 reads
SQL Server Encryption: Always Encrypted
Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.
2017-04-10
4,486 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers