There is no good reason for having ANSI_PADDING set to OFF when you create tables in SQL Server. It was provided purely for legacy databases that had code that assumed the old CHAR behavior for dealing with padding, and its use has now been deprecated.
2020-03-18
You’ve probably heard of Compliant Database DevOps, but to take it from buzzword to boardroom relies on demonstrating value across your business. IT leaders must think more broadly than cost savings and ROI calculations when investing in scaling DevOps across database teams.
Our latest whitepaper explains how to lay the foundations for a successful DevOps implementation, and how to track success against global metrics that demonstrate your team’s impact across the business.
2019-10-14
Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]
2019-07-10
2,553 reads
Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.
2019-07-04 (first published: 2019-06-20)
Phil Factor demonstrates how to use SQL Clone to create 'disposable' SQL Server databases, for development and testing work. You can spin up a clone, use it to unit test your code, messing up the clone in the process, then reset the clone in seconds, ready for the next test.
2019-06-04
Whenever you’re ready to refresh a test cell with the latest database version, you need a safe way to drop the current set of clones, and the parent image, without losing any unsaved work. Phil Factor provides a PowerShell script that automates this process so it runs in the time it takes to grab a coffee, after which can quickly deploy the new clones.
2019-04-19
The next version of SQLServerCentral will go love on Saturday, March 30, 2019
2019-03-29
289 reads
2018-12-24
39 reads
2018-09-21 (first published: 2016-01-04)
6,216 reads
2018-08-10 (first published: 2015-10-05)
4,776 reads
By Steve Jones
I downloaded SSMS 18.5, as there were a lot of fixes in here and...
By Steve Jones
I was excited to try the Jupyter Book feature in the March Azure Data...
I will be presenting a session to the Adelaide SQL Server User Group on...
We received error when testing the DBmail The mail could not be sent to...
i have a table A where the data looks like ID Name Phone CODE...
Comments posted to this topic are about the item Implementing Reporting Application Enhancements with...
Ask SSC