Load Time Series Data with SQL Server
In this article we look at how to load time series data into SQL Server both for an initial load as well as adding new data.
2020-02-05
Additional Articles
Building SQL Server Indexes in Ascending vs Descending Order
In this tip we look at the impact of building SQL Server indexes in ascending versus descending order and the impact.
2020-02-04
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
Changing SET options in a Procedure or Trigger leads to Recompilation (PE012)
Phil Factor delves into SQL Prompt's performance rule, PE012, which will advise you if it detects the use of the SET statements within a stored procedure or trigger, which might cause unnecessary recompilations, though the issue extends to other types of batches.
2020-02-03
How to Create an Ubuntu PowerShell Development Environment – Part 1
Since SQL Server now runs in Linux, more database professionals will begin to learn this operating system. In this article, Robert Cain demonstrates how to set up an Ubuntu virtual machine for learning.
2020-02-03
Power BI Advanced Q&A
What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?
2020-01-31
Cloning all the Databases on a Server
Phil Factor shows uses SQL Clone and PowerShell to automatically create images of all databases on an instance, if they don't already exist, and then create or refresh clones of each one, on all your development servers.
2020-01-30
SQL Server Attach and Detach Database Examples
In this article Dinesh Asanka looks at how to detach and attach a SQL Server database using the SSMS GUI and using T-SQL commands.
2020-01-30
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
Running Database Console Commands (DBCCs) on Azure SQL Database
Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands. However, there are some additional considerations that should be considered when using them in the context of Azure SQL Database deployments.
2020-01-29
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
BCA KCP Summarecon Mall Serpong Telp:0821°7555°651
Telp&Wa 628217555651 Down Town Walk, Summarecon Mal Serpong Unit DGF, Jl. Boulevard Raya Gading...
Alamat BCA KCP ITC BSD Telp:0821°8200°203
Telp&Wa 628218200203 Ruko ITC BSD, Jl. Pahlawan Seribu Blok R No. 41 & 42,...
Alamat BCA KCU ALAM SUTERA Telp:0821°8200°233
Telp&Wa 628218200233 Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers