Holiday parties: Do you love them or hate them?
It is getting to be that time of year. Holiday parties are you for them or against
How to Do a Free SQL Server Health Check
Brent Ozar shares a free script that that you can run to quickly produce a health check of your SQL Server.
Dynamically Create Warehouse Dimensions
Here's a data warehouse design pattern to speed up multi-value dimension creation.
Microservices in SQL Server
In SQL Server 2017 consuming or providing JSON data is so efficient that you can implement effective microservices right from the database, argues Phil Factor.
Missing Data
In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be plain wrong or it can be altogether missing. Sure, we have the NULL to signify unknown, but that doesn't play well with regular business reporting. There are a number of ways of dealing with missing information, and methods of estimating data from existing data has a long and respectable history. Joe Celko gets to grips with a data topic that is often treated with some trepidation.
Advanced Analytics with R & SQL: Part I - R Distributions
Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.
How Long Before You Upgrade?
This Friday Steve Jones wants to know about the lifetime of your instances. Do you have some idea on how long you'll run a particular version of a platform?
Mixing MongoDB and Relational Databases in the Enterprise
Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?
Change Integer to BigInt on a Very Large Table
This article will show how to change the data type of a column when the table contains more than 1 billion records.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
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