In 2005 Microsoft introduced the synonym functionality for SQL Server. While Synonyms are not something SQL developers are likely to use on a daily basis, they are very powerful and useful, despite being relatively simple. They are essentially a placeholder that can be used as a static value in a SQL statement that points towards another object. While staticRead more
When it comes to data access, I like to keep it simple. I prefer the database be exclusively responsible for database actions using stored procedures to execute queries and updates. I also like to avoid mapping lots of parameters in stored procedures. At other times, there’s a need for a way to send a listRead more
Introduction When working with a client in the hardware maintenance business, I developed an efficient and robust solution to solve a specific label printing business problem. This blog will discuss the business requirement and how I solved it with a simple solution using a message queue, DebuggableService, and XML Serialization. Business Requirements A few monthsRead more
After a bit of a spring break, I’m back! Believe me when I say March Madness is not limited to the basketball court. Hopefully, you have read through the first three blogs in this series and are anxiously waiting for this blog. (Well, I’d like to think you are.) In case you’ve found your wayRead more
In a series of blogs about the design and implementation of solutions using SQL Server Integration Services (SSIS), Part 1 addressed design tasks and whether or not to stage the data in an intermediate database or operational data store. Part 2 stepped through the setup of an SSIS project in SQL Server Data Tools (SSDT), defining projectRead more
In a series of blogs about the design and implementation of solutions using SQL Server Integration Services (SSIS), Part 1 addressed design tasks and whether or not to stage the data in an intermediate database or operational data store. This may be necessary if the data is being pulled from a number of different dataRead more
Hello! How is your week going? Did you just get slammed with a large, high priority data project? Or, are you in the middle of a project but aren’t sure how to get from point E to point L? If you’ve come across this blog post via a search for SSIS or Integration Services resources,Read more
SQL Server 2016 includes R Services and Advanced Analytics Extensions. R Services makes it possible to run R scripts within SQL Server. As a result, R analysis results can be delivered through Report Manager using SQL Server Reporting Services. What is R? R is a statistical programming language that is used extensively in scientific researchRead more
There are many types of indexes in SQL Server. One of the less commonly-used types is a Filtered Index. This blog explores scenarios for using a filtered index, so that you know when it should be applied to be most effective.
Introduction A NoSQL database defines a type of database that is non-relational. Some advantages of a NoSQL database over Relational databases include: Low latency High performance Highly scalable NoSQL databases such as MongoDB can be easily accessed through programming languages such as C#. This blog provides an example of using C# to perform the fourRead more
