CLOUD SQL 

Benefits of using SQL Server Temporal Tables with Memory Optimized Tables – Part 4

By: Ameena Lalani   |   Read Comments   |   Related Tips: More > Temporal Tables Problem In previous tips we look at some of the benefits of using Temporal Tables.  In this tip we look at some of the benefits of using Temporal Tables with memory optimized tables Solution In Part 1, Part 2 and Part 3 of this tip series, several benefits of temporal tables were discussed. This is the last tip of this series.…

Read More
CLOUD SQL 

How to Create Dumbbell Plots in SQL Server Reporting Services

By: Koen Verbeeck   |   Read Comments   |   Related Tips: > Reporting Services Development Problem I’d like to create a dumbbell plot in SQL Server Reporting Services (SSRS), but the chart type is not available there. How can I create such a visualization in SSRS using the built-in tools? Solution In this tip, we’ll show you how you can create a dumbbell plot using SQL Server Data Tools (SSDT) and the built-in visualization types. A dumbbell plot…

Read More
CLOUD SQL 

SQL Server Current Identity Value Report for All Tables

Hi Eli, thanks for putting this script together. I have been using it, however, I need to do 2 changes: 1) needed to add the “not for replication” column because this is a very important information when dealing with identity columns (if you have replication) 2) reduced the output of the column “Type_limit” otherwise it would be 8000 and that is not good for my requirements. The following is the script altered, you can add those features to your post and delete this comment,…

Read More
CLOUD SQL 

Deciding to use SQL Server 2017 Express Edition

By: Daniel Farina   |   Read Comments   |   Related Tips: More > Express Edition Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem You need a database solution for your application, but you don’t want to purchase additional database licenses if you don’t need to. Before selecting a database platform, a colleague tells you about the SQL Server 2017 Express…

Read More
CLOUD SQL 

Using Two Samples to Validate MACD with T-SQL

By: Rick Dobson   |   Read Comments   |   Related Tips: More > T-SQL Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem I am seeking a demonstration of how MACD indicators describe the path of stock prices. Please present examples linking all three MACD indicators to stock prices using two different samples of stock symbols in a SQL Server table.…

Read More
CLOUD SQL 

Handling SQL Server transactions in nested stored procedures using Savepoints

By: Sergey Gigoyan   |   Read Comments   |   Related Tips: More > Transactions Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem It is essential to manage a transaction inside nested SQL Server stored procedures to avoid the error “Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0.” …

Read More
CLOUD SQL 

No More Service Packs for SQL Server

By: Rajendra Gupta   |   Read Comments   |   Related Tips: More > Database Administration Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem SQL Server 2017 was released in October 2017 with many new features and upgrades. You might have heard that Microsoft will no longer be providing service packs.  In this tip we look at how updates will now…

Read More
CLOUD SQL 

Pre-validating Data in Delimited Files with PowerShell Prior to Importing to SQL Server

By: Tim Smith   |   Read Comments   |   Related Tips: More > PowerShell Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem We have thousands of comma-delimited files that have a header row, along with rows of data with the first column being the definition of the row (similar to a key value format, except the value is actually comma-delimited…

Read More
CLOUD SQL 

Anomaly Detection without any coding using Power BI

By: Siddharth Mehta   |   Read Comments   |   Related Tips: More > Power BI Attend this free live MSSQLTips webcast SQL Server MVPs and Industry Experts Share Their Database Secrets Thursday, June 28, 2018 - click here to learn more Problem Detection of anomalies in quality control, financial frauds, web log analytics for intrusion detection, medical applications, etc. have immense importance as well as applications. Almost all the anomaly detection employs one or other form of outlier …

Read More
CLOUD SQL 

How to Install SQL Server Migration Assistant for Oracle Extension Pack � Part 2

By: Manvendra Singh   |   Read Comments   |   Related Tips: More > Other Database Platforms Attend this free live MSSQLTips webcast Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale Thursday, June 28, 2018 - click here to learn more Problem Organizations are moving their applications from Oracle to SQL Server to reduce their TCO and Microsoft has developed a tool called the SQL Server Migration Assistant for Oracle to migrate databases from…

Read More