TCP Chimney Offload transfers network traffic workload processing from the CPU to a network adapter that supports TCP Chimney Offload. This feature was introduced with Windows Server 2003 SP2, and it was called the Microsoft Scalable Networking Pack (SNP). Since Windows Server 2008, these features are a base part of these operating systems, so they […]
How to ensure that all the SSRS features are working while using Always On Availability Groups OR have an RSExecRole as a default
This blog post addresses SSRS on Always On and RSExecRole. To make sure I’m staying laser focused on this topic, I need to cover some fundamentals.
SSRS installation (SQL Server 2017 and later)
Starting from SQL Server 2017, Microsoft decided to separate SSRS from a SQL Server installation container (ISO). Keeping the pros and cons of this […]
I’ve seen this question a few times and it is something that can be very confusing: You’ve installed SQL 2014 (a full version, not Express) and selected all components, yet when you go to your SQL Server 2014 program group, you can’t find SQL Server Data Tools.
In all versions of SQL Server between 2005 and […]
I’m a loserI’m a loserAnd I’m not what I appear to be
— John Lennon
As a SQL Server or other IT professional, do you ever feel like you’re doing it with smoke and mirrors? Do you fear you’ll soon be exposed as a pretender? Do you feel like a fraud, merely acting in your role? You’re […]
There is a lot of information within the Windows registry. Sometimes, it would sure be nice to work with the registry in SQL Server through your T-SQL scripts. As it turns out, there are several undocumented extended stored procedures in SQL Server that do just this. A listing of these procedures are:
As you can see, […]
So, it’s here: a global pandemic impacting billions around the globe and changing the ways we live, work, and interact with each other. Our new normal, for an unknown length of time, is all about social distancing and that means working from home for many of us.
At SSG, this is nothing new to us, and […]
IT expenditure decisions are never purely financial, as those who pull the trigger must consider how the purchase, or perhaps delaying the purchase, could impact other departments, from marketing and regulatory to operations and human resources. Once you have made the decision to proceed with an outlay, you then must decide: Capital Expenditure (CapEx) or […]
Data Governance plays an important role in building a successful data-driven company as it helps business users to trust the data. While a typical Data Analytics project starts with identifying all relevant transactional sources of information, building your Data Warehouse according to business needs and feeding (and converting) the data as often as possible, one […]