(Chris Webb) When DirectQuery mode for Power BI was announced I assumed it was just the next version of SSAS Tabular DirectQuery mode with the same extra features that we’ll get in SSAS 2016 (such as better SQL generation, and other benefits enabled by Super-DAX).
Tag: sql server
SQL SERVER – Save and Send Execution Plan Via Email
(Pinal Dave) Here is an interesting question, I received the other day.
Database Continuous Integration with SQL CI and Jenkins
(Jason Crease) Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system.
Azure SQL Database Resiliency – Point-in-Time Restore
(Marcin Policht) Azure SQL Database provides a number of benefits that leverage resiliency and redundancy built into the underlying cloud infrastructure. You can take advantage of these features in order to perform backup, restore, and failover tasks, which help you recover from human errors, servic
SQL Server Express idle feature causes .NET SQL error: TCP Provider The specified network name is no longer available
(Steve Endow) I just spoke with a partner who is testing Post Master Enterprise, which is a .NET application that automatically posts Dynamics GP batches.
What is the Difference Between Cast and Convert?
(Kris Wenzel) In this article we’re going to explore the CAST and CONVERT functions to understand whether there are any significant differences worth knowing when we want to convert data from one type to another.
Automatically name primary key constraints in SSDT
(Ed Elliott) There are some things you see when writing t-sql code and schemas that just look sloppy, one of those is unnamed constraints, what you see is:
T-SQL Search Snippets
(Derik Hammer) Here are two snippets that I use often to search for objects on a variety of servers. The first will search any object within a database and the second will search various elements of SQL Agent jobs.
SQL SERVER – How to Change SQL Server Product Key or License Key?
(Pinal Dave) I try to refrain from talking about licensing related topics because they seem to be complicated and have tons of permutations and combinations. Having said that, in the recent past, I was baffled to see this query land to my Inbox which was interesting and needed some attention from me
SQL Symmetric Encryption TSQL
(Vinoth N Manoharan) Recently my client wanted to create a password vault in SQL database to store SQL Server service account, SQL users and their respective passwords. I used symmetric key to create encryption for the encrypting the password, Find the T-SQL below to accomplish this.