Scott Kaufman

74 Flips | 8 Magazines | 3 Likes | 4 Followers | @scottyk537 | Keep up with Scott Kaufman on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Scott Kaufman”

Linkedin

Working with the SQL Server command line (sqlcmd)

Working with sqlcmd interactive mode<p>In interactive mode, you can write the input and interact using the command line.<p>How to connect to SQL Server …

Are Implicit Conversions Killing Your SQL Query Performance?

Have you ever encountered a query that runs slowly, even though you’ve created indexes for it?<p>There’s a few different reasons why this may happen. …

Script to identify all non-indexed foreign keys in a SQL Server database

By: Eli Leiba | Read Comments | Related Tips: More > Indexing<p>Problem<p>The requirement is to create a query that will identify all SQL Server foreign …

Databases

Tighten SQL Server security with custom server and database roles

Check out this tip to learn how to limit DBA level access in SQL Server by building custom server and database roles.

Databases

Simple Image Import and Export Using T-SQL for SQL Server

<b>Tuesday, April 17, 2018 - 4:52:35 PM - Carlos Torres</b><p>Hi Eli,<p>I did all those steps in a SQL Server 2008<p>I dont get any error message but when I checked …

Databases

SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?

<b>Question:</b> How to Find Row Count of Every Table in Database Efficiently?<b>Answer:</b> There are some questions which are evergreen. I recently asked this …

Databases

Deploying Multiple SSIS Projects via PowerShell

OverviewThis article describes a way of using PowerShell to deploy multiple SSIS projects as part of a database or data warehouse deployment. It …

Databases

Visual Checks on How Data is Distributed in SQL Server

This article is all about how to go about looking at a visual representation of the way that data is distributed in tables, in a quick unpolished …

Databases

SQL Server Performance Baselining Reports Unleashed for Enterprise Monitoring !!!

In my previous blog post, I had shared how you can leverage SQL Server Performance Dashboard SSRS Reports for monitoring and point in time …

Script to Capture Performance Stats When Testing SQL Server T-SQL Statements

By: Dallas Snider | Read Comments (2) | Related Tips: More > T-SQL<p>Problem<p>I need to test a SQL Server T-SQL statement and collect information on its …

Databases

Different Ways to Flush or Clear SQL Server Cache

In this tip we look at different ways to flush the SQL Server cache.

Databases

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1

By: Edwin Sarmiento | Read Comments (3) | Related Tips: 1 | 2 | 3 | More > Clustering<p>Problem<p>In a previous tip on Validating a Windows Cluster Prior …

Find All Queries with Implict Conversion in SQL Server – Interview Question of the Week #107

<b>Question:</b> How do I find out how many queries have an Implict Conversion in SQL Server?<b>Answer:</b> The source of this question is very interesting. …

Databases

Copy a SQL Server database with just the objects and no data

Problem<p>I sometimes get requests to copy a database from one server to another without any data. I just need an empty database with just the schema …

Databases

Exam material for the Microsoft 70-764, Administering a SQL Database Infrastructure

Problem<p>I am going to take the Microsoft exam 70-764, Administering a SQL Database Infrastructure. I would like to know what materials I can use to …

Databases

These 10 widgets belong on your iPhone's lock screen

Get your must-have widgets here.<p>With iOS 10, Apple redesigned the lock screen and got rid of the slide-to-unlock gesture. Now, instead of unlocking your phone, swiping right takes you to the Today view where you can glance at and interact with widgets.<p>You can also access these same widgets on an …

Apps

10 SQL Tricks that You Didn't Think Were Possible

SQL is the winning language of Big Data. Whether you’re running a classic relational database, a column store (“NewSQL”), or a non-relational storage system (“NoSQL”), a powerful, declarative, SQL-based query language makes the difference. The SQL standard has evolved drastically in the past …

Understand how SQL Server works to write better T-SQL queries

By: Susantha Bathige | Read Comments (3) | Related Tips: More > T-SQL<p>Problem<p>Recently I saw a forum question about a T-SQL query which seems to be …

Databases

Week 1 Database Corruption Challenge

The week 1 Database Corruption challenge was a hit.<p>Here is a list of blog posts that made up the first challenge.

Snapshot Isolation Level and Concurrent Modification Collisions - On Disk and In Memory OLTP

This is part 1 of my In Memory OLTP blogs for my upcoming book project. In this blog I want to take a (reasonably) quick look at how concurrent …

Databases

101 Things I Wish You Knew About SQL Server

Last week I was visiting the SolarWinds home office in Austin and hanging with my fellow Head Geeks. Our conversations often cover a wide range of …

Identifying SQL Server 2014 New Cardinality Estimator issues and Service Pack 1 improvement

In a previous blog, I talked about SQL 2014’s new Cardinality Estimator (new CE) and trace flags 9481 and 2312 can be used to control which version …

VM Memory Counters Lie for SQL Server VMs | Convergence of Data and Infrastructure

A few weeks ago, while at the incredible SQL Saturday Madison, I had a great discussion with a few of the other speakers about SQL Server VM-level …

Bad I/O Performance on SQL Server?

<b>1. Check the Data Cache Hit Ratio of your database!</b><p>One of the most important things to configure is the memory for SQL Server. If you observe a bad …

SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

While talking to one of the attendees after my session at GIDS, I realized that I don’t have much information available on my blog about the usage of …

Databases

SQL SERVER – Identify Page Splits Using Extended Events in SQL Server

Digging some of my older posts reveal I have written a blog already on Page Splits with SQL Server. This was no surprise because I am in constant …

Databases

Monitor SQL Server Transaction Log File Free Space

By: Mike Eastland | Read Comments (2) | Related Tips: More > Monitoring<p>Problem<p>There are two kinds of SQL Server DBAs in this world: those who have …

SQL SERVER – Script: Current IO Related Waits on SQL Server

Playing around with DMVs is so much fun. Many a times we need little inspiration and a problem in hand to solve. Out of many things I monitor, I have …

Databases