Additional Articles

All authors

External Article

Static data in SQL Change Automation SSMS plugin

Kendra Little sat down with the SQL Change Automation Dev Team to get some insight into how they build the product with the customers in mind. SQL Change Automation 4.1 included adding support for the tracking of static data tables to the SSMS extension. This was a direct result of the communication and work the team have carried out with their customer base. Read Kendra’s blog to find out more about the release and the work that goes into delivering these updates.

2020-02-04

External Article

Removing the Square Bracket Decorations with SQL Prompt

If you avoid illegal characters and reserved words in your identifiers, you'll rarely need delimiters. Sadly, SSMS applies square bracket delimiters indiscriminately, as a precaution, when generating build scripts. Phil Factor provides a handy function that adds quoted delimiters only where they are really needed and then sits back and lets SQL Prompt strip out any extraneous square brackets, in a flash.

2020-01-29

External Article

Basic Concepts of Probability Explained with Examples in SQL Server and R

Many organizations have known the fact that data have been evolved from the by-product of corporate applications into a strategic asset [1]. Like other corporate assets, the asset requires specialized skills to maintain and analyze. With modern data analytic tools, for example Python, R, SAS and SPSS, IT professionals can build models and uncover previous unknown knowledge from the ocean of data.

2020-01-27

1 reads

All authors

Blogs

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Monday Monitor Tip: Compliance Checking for Old Versions

By

A customer recently wanted to know if any of their instances were too old...

Read the latest Blogs

Forums

Cleaning Up Your Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cleaning Up Your Database

Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Exploring Time Travel and Row...

Memory-Optimized Tables Memory

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Memory-Optimized Tables Memory

Visit the forum

Question of the Day

Memory-Optimized Tables Memory

Memory-Optimized tables should fit in memory to work efficiently. Aside from the data size, how much overhead is required for each row?

See possible answers