Implementing Fuzzy search in SQL server

  Fuzzy Search in SQL Server is not done very well. This post will cover how to implement Fuzzy Search capabilities using several approaches.   What is it? Fuzzy Search is the process to locate records that are relevant to…

Read More >

SQL server row level security

  Row Level Security (RLS) has been implemented in SQL Server 2016 for both on-premise and v12 of Azure instances. The problem this solves is: a company with multiple applications accessing sensitive data in one or more tables. How do…

Read More >

Running SQL server jobs against an Azure SQL database

  I recently had a client ask how to run SQL Server jobs against an Azure SQL Database, and because SQL DB doesn’t have an SQL Agent like most other versions of SQL Server, it isn’t always obvious how to…

Read More >

SQL On The Edge #4 – SQL 2016 Stretch Database

  As the Microsoft SQL Server team continues to build very interesting integrations between the full SQL Server box product we all know and the Azure cloud platform. Stretch database is another integration that will be included as part of SQL…

Read More >

The 2nd Annual PASS Summit Bloggers Meetup (2015)

I’m excited to announce the second annual PASS Summit Bloggers Meetup! We began this last year and it was cool but this year will be even cooler! What: PASS Summit Bloggers Meetup 2015 When: Thursday, October 29th, 5:30pm Where: Sports Restaurant…

Read More >

SQL server fast food

  An environment where you have a high number of databases on one server, or many, can be time consuming to something as simple as adding a user account. You have the option of using the GUI with SQL Server Management…

Read More >

Issues with Plan Cache Reuse & Row Goal Optimization

  I am presenting here on behalf of my colleague  Fabiano Amorim (he is busy resolving other exciting performance issues…  :-D ) . Fabiano had an interesting case with one of our customers that is very common in SQL Server. The…

Read More >

SQL On The Edge #3 – Azure elastic database jobs

Hello and welcome to episode number three of SQL On the Edge! In this episode we’re going to cover Azure SQL elastic database jobs. In the last few months, Microsoft has put a lot of effort in augmenting the elastic…

Read More >

SQL Server: migrations/upgrades – 10 things to think about

Here at Pythian we have planned and implemented dozens of migrations and upgrades for our customers. In this blog post I am trying to summarize the 10 most important things to consider when migrating or upgrading a SQL Server environment,…

Read More >

Import/export multiple SSIS packages

While I was working on a migration project recently, I had the task of importing and then exporting multiple packages – about 120~ on to a new server. Usually, if there are less numbers of packages we can do this task manually…

Read More >
Page 10 of 23« First Page...89101112...20...Last Page »