Small identity columns
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small...
2017-10-17 (first published: 2017-10-09)
1,849 reads
Blog Posts
Database Fundamentals #14: Modifying Data Through SSMS
I’ve said it before, but I feel I should repeat myself. Using the SSMS GUI for data entry and data...
2017-10-16
535 reads
Feeling Stunned
If you work in the Microsoft technology space you are probably aware of the mass of people who refresh their...
2017-10-16
340 reads
Feeling Stunned
If you work in the Microsoft technology space you are probably aware of the mass of people who refresh their...
2017-10-16
147 reads
How to Perform and schedule SSAS Backups ?
Steps to configure schedule SSAS Cube \ OLAP database backups :-
1. For each SQL Server Analysis Services Environment. In order to...
2017-10-16
1,422 reads
Power BI Custom Visuals Class (Module 73 – Heat Streams)
In this module you will learn how to use the Heat Streams Custom Visual. The Heat Streams visual allows you...
2017-10-16
830 reads
Speaking at IT/Dev Connections 2017 – San Francisco!
I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my...
2017-10-16
343 reads
Speaking at IT/Dev Connections 2017 – San Francisco!
I’m proud to announce that I will be delivering two sessions at IT/Dev Connections in San Francisco! This is my second year at IT/Dev Connections, real content for IT...
2017-10-16
3 reads
SQLpassion Online Training about Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-10-16 (first published: 2017-10-09)
1,262 reads
Understanding ANOVA
ANOVA – or analysis of variance, is a term given to a set of statistical models that are used to analyze...
2017-10-16 (first published: 2017-10-09)
2,532 reads
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
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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