If it's deemed important to test application code as part of a CI process, the same must apply to the database. In this blog post, Jason Crease shows how to create a smooth process where you can build and deploy databases alongside your application code from within Jenkins with the SQL CI plugin.
2015-12-10
3,631 reads
This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.
2015-12-09
5,169 reads
Dan Holmes shows how you can create statistics exactly the way you want within the bounds of the 200 steps available.
2015-12-09
2,745 reads
Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code
2015-12-08
2,169 reads
Jovan Popovic talks about transforming complex relational structures into simpler tables using JSON format.
2015-12-08
4,095 reads
Phil Factor's newest SQL expression calculates when all the feasts and saints days are, giving you plenty of potential causes for celebration.
2015-12-07
2,675 reads
This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.
2015-12-04 (first published: 2014-09-23)
32,982 reads
SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be the most significant enhancement of SQL Server 2016 - Enrico van de Laar explores.
2015-12-04
4,278 reads
Power BI designer is based upon the Power Query formula language informally known as "M". Unfortunately, the advanced editor inside the Power BI designer does not support syntax highlighting, meaning it can be easy to make mistakes. Matt Mason shows how you can extend the Notepad++ editor to support this feature.
2015-12-03
3,200 reads
In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.
2015-12-02
3,785 reads
A RAG pipeline that answers questions in the demo is not the same thing...
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Comments posted to this topic are about the item Looking for New Blood
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers