Publish to Pyramid Server (P2PA)
Download this whitepaper for an in-depth look into the P2PA feature and how it’s empowering BI users. read more
The Healthcare Landscape Has Changed
Download this eBook to learn how you can use your own data-driven insights to reduce costs without reducing quality of care. read more
Better Decisions for Everyone
Download this whitepaper to learn how to become a data-driven organization with a complete analytics platform that is defined by four key attributes. read more
Sort Query Using Dynamic Variables Without EXEC – Interview Question of the Week #074
It does not matter which version of SQL Server we are using, I think this question is going to be there universally all the time when people want to sort query using dynamic variables. Trust me, this is indeed a popular question. After 14 years of …
Converting an SSIS 2014 Solution to SSIS 2016
Microsoft SQL Server Data Tools (SSDT) supports “deployment targets.” This means you can use the same Integrated Development Environment (IDE) to build SSIS packages targeted for deployment to the SSIS Catalog on a SQL Server 2012, 2014, or …
Using SQL Server 2016’s New Dynamic Data Masking
Understand when to use and when not to use Dynamic Data Masking. read more
SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.
Generally, I like to pick and choose the way various services are installed when working with SQL Server. I am careful not to have unnecessary services like “Reporting Services”, “Agent” etc running. I install them and keep them …
Avoid these Four Critical DBA Mistakes
Database Admins: Don’t make these common errors. read more
SSMS 2016: It Just Runs More Awesomely
Step 1: configure SSMS to only show file names on the tabs. Click Tools, Options, Text Editor, Editor Tab and Status Bar, and set all of the tab texts to false except file name. After all, not like all this stuff fits on the tab. Step 1: SSMS tab name …
Licensing and upgrade options for Analysis Services Tabular in SQL Server 2016 #ssas #tabular
With the release of Microsoft SQL Server 2016, there are several options to use Analysis Services Tabular. SQL Server Standard: it includes Analysis Services Tabular, and it is available in two licensing models: Server + Client Access License (CAL) and …
Is your SAN’s cache killing tempdb?
Let’s start with definitions Many SANs have caching built in. What kind of cache is important, because if you’re dealing with non-SSD storage underneath, you could be waiting for a really long time for it to respond. Let’s start with …
Installing SQL Server 2016 Developer Edition, One Example
There are lots of options when installing SQL Server 2016 Developer Edition. I am not going to exhaust them. I will, however, share how I set up SQL Server 2016 to begin learning about the relational engine, SSIS, and SSRS. First, you need SQL Server 2 …
The End of Big Data
What is next for big data? Some experts claim that data « volumes, velocity, variety and veracity » will only increase over time, requiring more data storage, faster machines and more sophisticated analysis tools. However, this is short-sighted, and does …
OmniCompare: How do your SQL Servers differ?
When you have an issue on standardized kit, your first question is usually what’s changed or how is this server different to the others. Has a setting been changed? A job disabled? Aireforge OmniCompare was developed to help diagnose such issues, …
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!