Database provisioning for development work isn't always easy. The better that development teams meet business demands for rapid delivery and high quality, the more complex become the requirements for the work of development and testing. More databases are required for testing and development, and they need to be more rapidly kept current. Data and loading needs to match more closely what is in production. Grant Fritchey explains.
This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpson's Paradox.
Today, Steve Jones looks at the popularity of SQL Server, which was named DBMS of 2017.
Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.
SQLServerCentral is getting an upgrade, and Steve Jones has a few words.
It is foolish to insist on reading only up-to-date books on technology. Nothing beats getting the broad perspective.
Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.
When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQLite version of the old PUBS database that the first generation of RDBMS developers cut their teeth on.
Get the basics of what a container is and how this can work with SQL Server.
In this piece by Pilip Horan, learn how to create an SSIS catalog and run a project as a SQL Agent Job.
Reading tutorials is fine. Shipping something is better. If you are trying to break...
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Comments posted to this topic are about the item Liability for AI Errors
Hello , I would like to run a stored procedure on a secondary replica...
Comments posted to this topic are about the item Pro SQL Server Internals
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers