(Michael Otey) Microsoft software licensing can be tough to manage — so let’s analyze some of the different situations for licensing SQL Server 2016 that enterprises will likely face.
Tag: sql server
(Jon Gallant) We often need to share database connection strings, system account passwords and whatnot with our team members. People typically put the secret in a DRM’d email, but that’s not secure enough and you can’t copy and paste them. There’s a better way with Azure Key Vault and Azure Key Vaul
(Camilo Reyes) Node.JS and SQL Server are a good match for creating non-blocking, event-driven database applications. Though you can use ODBC or JDBC to communicate between the two, it is possible to run such applications on platforms such as Azure, Linux, OSX and iOS by using Node together with the
(Grant Fritchey) I was asked if there was an easy way to export all the plans from cache to a .SQLPLAN file. My immediate answer was, “I’m sure there’s a PowerShell script out there somewhere.”
(Chris Webb) In my last two blog posts (see here and here) I showed how to use the Calculation Evaluation and Calculation Evaluation Detailed Information trace events to work out which MDX calculations are evaluated when a query runs in Analysis Services Multidimensional.
(Christina Phillips) From time to time, we still get inquires from folks building views in SQL server that actually already exist. So I thought I would post a quick reminder that every SmartList has a SQL view that corresponds and can be used for your own purposes as well (e.g., SQL reports, Excel
(Kathi Kellenberger) There are several chart types found in traditional paginated SSRS reports. The charts have many properties, but these are configured the same from chart type to chart type. SSRS Mobile report charts are very different. Each chart has a specific purpose and unique properties.
(Jose M Jurado) Today, we were working on a service request where our customer reported that, some TRUNCATE executions are taking more time that they expected. Normally, these TRUNCATE commands just only take 3 or 5 seconds to complete, however, this time, the problem is that they never finish.
(Jack Vamvas) Question: I need some sql code to record the row count of every table in a database.
(Kenneth Fisher) In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well here’s another one.