SQL Server Agent for SQL Express on Linux
This article will show you how to use crontab to schedule tasks that you want to run on a SQL Server on Linux instance when no Agent is configured.
2019-06-18
1,040 reads
Articles
Resolving could not open a connection to SQL Server errors
Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.
2019-06-18
2019-06-17
1,561 reads
SQL For Cosmos DB – Handling Complex JSON Structures
The JSON documents that are part of Cosmos DB document collections can be complex with arrays and nesting. In this article, Adam Aspin shows you how to query them with SQL.
2019-06-17
SQL Server Performance Benchmarking with Patterns
A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.
2019-06-14 (first published: 2017-10-19)
2,443 reads
Reporting Services Basics: Creating Your First Report
In this article, Kathi Kellenberger demonstrates how to create a project and report using the SSRS Report Wizard. The wizard is fine for getting started, but you’ll soon learn about its many limitations. She also explains how reports fit in projects and solutions.
2019-06-14
Managing SQL Server containers using Docker SDK for Python - Part 1
There are multiple ways to interact with the Docke...
2019-06-13
2,087 reads
How to Copy a Table in SQL Server to Another Database
Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
2019-06-13
Free eBook: SQL Server Execution Plans, Third Edition
If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem.
2019-06-12 (first published: 2013-07-30)
119,575 reads
SQL Server Common Table Expression vs Temp Table
In this tip we look at how to use Common Table Expressions CTE in SQL Server including the syntax, use cases, using more than 1 CTE at the same time and recursive CTEs with a parameter.
2019-06-12
Blogs
Cool Stuff in Snowflake – Part 9: ILIKE
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...
Scalar Valued Functions in SQL Server 2019
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Globally Distributed Azure Cosmos DB
By Arun Sirpal
Let’s use the Azure portal to build a globally distributed Cosmos DB. Before doing...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Upgrade SQL Server 2012 R2 cluster to 2016 by adding 2016 node
We have a SQL Server 2012 R2 failover two-node cluster that we'd like to...
Power Shell script to add a user to sysadmin server role on many SQL instances
Can someone please copy/paste or provide me the script for this? The list of...
Ask SSC