Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 


MSSQLTips

Vote for your favorite MSSQLTips authors

Only 2 weeks left to vote!

Author: MSSQLTips



David Terry

Next Webcast - How to Simplify Routine SQL Server Administration Tasks

Join this webcast to see how SQL Admin Toolset simplifies routine administrative, monitoring, reporting, and troubleshooting tasks.

Author: David Terry



SIOS

Affordable SQL Server High Availability

Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups.

Author: SIOS



Douglas Correa

PowerShell AWS Tools for Fast File Copy

Learn how to have a fast file copy with the PowerShell AWS tools.

Author: Douglas Correa



Aaron Bertrand

Changes to CXPACKET waits in SQL Server

In many OLTP systems, parallelism is only truly useful on a subset of queries. Most of the typical workload is comprised of quick queries that affect a small number of rows and, in turn, consume very little in terms of resources. When queries do end up us

Author: Aaron Bertrand



Quest

Whitepaper - Simplify Your Database Migrations and Upgrades

You can say "migrations and upgrades" to a database administrator (DBA) or systems administrator, but what they usually hear is "risk and downtime". This e-book shows you how to simplify the migration and upgrade process so you can avoid the risks.

Author: Quest



Jugal Shah

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.

Author: Jugal Shah



Greg Robidoux

Simple script to backup all SQL Server databases

Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a

Author: Greg Robidoux



Arshad Ali

SQL Server CROSS APPLY and OUTER APPLY

SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APP

Author: Arshad Ali



Siddharth Mehta

SQL Server 2017 and Python Tutorial

This tutorial is intended to help experienced T-SQL Developers, DBAs, Data Analysts and Data Science enthusiasts to start using Python language with T-SQL. This enables data science and analytics tasks closest to the actual data.

Author: Siddharth Mehta



K. Brian Kelley

Auditing Failed Logins in SQL Server

An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?

Author: K. Brian Kelley



Daniel Farina

How to Attach a SQL Server Database without a Transaction Log and with Open Transactions

You want to attach a SQL Server database that does not have the transaction log files and get the following error: “The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database

Author: Daniel Farina



MSSQLTips.com

Free Lunch from MSSQLTips.com - Register Now

MSSQLTips is giving away $50 USD that you can use to take your team to lunch. We know you work hard as an IT Professional, so here's a little token to show our appreciation for what you do.

Author: MSSQLTips.com



Haroon Ashraf

Free Database Unit-Testing for SQL Server Data Tools

Check out this free database unit testing tool when using SQL Server Data Tools.

Author: Haroon Ashraf



Siddharth Mehta

Graph Analysis using Force Directed Graphs in Power BI Desktop

In this tip we will learn how to use a force directed graph in Power BI Desktop.

Author: Siddharth Mehta



Haroon Ashraf

Free Database Unit-Testing Framework for SQL Server

Learn how to implement an advanced and cost-effective database unit-testing framework with tSQLt in SQL Server Management Studio.

Author: Haroon Ashraf



Atul Gaikwad

Automate refresh of a SQL Server database that is part of an Availability Group

Check out this tip that shows the steps to automate refreshing a database that is part of an AlwaysOn Availability Group.

Author: Atul Gaikwad



Rick Dobson

Import end of day prices for all NASDAQ stocks into SQL Server

In this tip we look at how to import every NASDAQ stock price and volume into SQL Server.

Author: Rick Dobson



Eli Leiba

SQL Server Stored Procedure to get every Nth row of a Query Result Set

Check out this simple SQL Server Stored Procedure to get every Nth row of a query's result set that does not use any Loops, complex OFFSET-FETCH statements or cursors.

Author: Eli Leiba



Daniel Calbimonte

Microsoft Professional Program (MPP) Overview

Get all of your questions answered for the Microsoft Professional Program (MPP).

Author: Daniel Calbimonte



Viacheslav Maliutin

Lessons to Solve SQL Server Deadlocks with Foreign Keys - Part 2

Learn how to solve SQL Server Deadlocks with multiple foreign keys columns when a table scan is occurring.

Author: Viacheslav Maliutin



Koen Verbeeck

Reduce the Size of an Analysis Services Tabular Model – Part 2

In this tip we’ll show different techniques on how to shrink the size of particular columns for an Analysis Services Tabular Model.

Author: Koen Verbeeck



Edgewood Solutions

Notes from the field: Visual Studio Live Orlando FL Contest Winner

Michael Knell was our VS Live Orlando winner. Check out what he has to say about the event.

Author: Edgewood Solutions



Daniel Farina

Monitoring SQL Server Blocked Sessions with SQLCMD

In this tip we look at useful scripts that can be used with sqlcmd to help troubleshoot blocking issues.

Author: Daniel Farina



Nat Sundar

Deploy Multiple SQL Server Integration Services SSIS Projects Using C#

Check out this tip to learn how to deploy multiple SSIS projects using C# code.

Author: Nat Sundar



Edwin Sarmiento

Installing SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 2

In this tip we look at configuring network adapters and storage spaces direct when setting up a SQL Server 2016 failover cluster.

Author: Edwin Sarmiento



Sergey Gigoyan

Debugging T-SQL Code in SQL Server Management Studio

In this tip we look at how to use the debug feature in SSMS.

Author: Sergey Gigoyan



Starwind

Deploying SQL Server 2016 Basic Availability Groups Without Active Directory Part 1 Building the Platform

When Availability Groups were introduced in SQL Server 2012, they were only available in Enterprise Edition. This made it challenging to move from Database Mirroring to Availability Groups, especially if you’re running Standard Edition.

Author: Starwind







Learn more about SQL Server tools