Latest Blog Posts
By Steve Bolton
…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to implement statistical formulas, in order to derive measures that required some explanation before they could be interpreted correctly. In this segment of the series, we’ll be discussing a… Read more
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can generate a…
For a recent presentation on using availability groups for disaster recovery, I needed a test environment that contained multiple separate subnets – something that approximates what you’d see in an enterprise that has multiple remote data centers. I found bits and pieces of the configuration on other sites, but nothing… Read more
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas! The conference is held September 14-17th at the ARIA Resort. My two sessions are:
Maintaining the performance of a mission-critical SQL Server… Read more
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on their 2014 instance in order to validate performance after an upgrade. The plan was to use query hash values. I was curious, so I set up a quick test. First,… Read more
For different reason we need to send database report , data and other SQL Server database related stuff using E-mail . SQL Server provides E-mail functionality using “Database Email” feature. We can setup any E-mail in few simple steps.
Let’s follow below steps
Step 1:- Open “ Read more
If you would have asked me 2 years ago if I had ever considered public speaking my response would have been a definitive no! In the words of the cowardly lion, “Not no way! Not no how!”.… Read more
If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have to brush up on…
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been created with the durability option of SCHEMA_ONLY meaning that data will not be retained. However there is another durability option of SCHEMA_AND_DATA which means that SQL will retain… Read more
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant ways. A short definition of this new feature would be: it allows us to write a single statement to synchronize data in two tables by executing any combination of INSERT,… Read more
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement. You can use this to record what workstation the transaction came from in your application or business intelligence processes.
HOST_ID will return the Process ID from the client… Read more
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions to create/modify jobs? How about SSIS packages?
However the msdb database has… Read more
Object variables in SSIS are incredibly versatile, allowing the storage of almost any type of data (even .NET objects). In my last post on this topic, I demonstrated how an SSIS object variable containing a .NET DataSet object could be used by the for each loop container as an… Read more
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever, because nobody knows whether they’re used or not. Sometimes it’s really hard to tell. Some databases are accessed by a huge number of applications, reports, ETL tools and God knows… Read more
I’ve been intrigued by Windows Phone as a platform. I’ve never owned one, and while I considered getting one, the dearth of apps led me to an Android instead. I really tried to get down to a list of core apps that I needed, which was 12 or 15 at… Read more
I’m proud to announce my company, Heraflux Technologies, is looking to fill the position for Vice President of Business Development. When we first started our company in September 2013, we had a number of short and long term goals about how we wanted to grow and scale our… Read more