(Chris Webb) If you need to write queries in SQL Server Management Studio against an SSAS cube that has its Visible property set to false, you have a problem because when you connect to your database you can’t see the cube or its metadata!
Tag: sql server
What are SSRS Mobile Reports?
(Kathi Kellenberger) SQL Server Reporting Services (SSRS) has been around since 2004.
Estimated Number of Rows to be Read
(Rob Farley) Don’t get me wrong – I love the Actual Rows Read property that we saw arrive in SQL Server’s execution plans in late 2015.
Query Store and In-Memory OLTP
(Enrico van de Laar) Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics?
SQL Server Always Encrpted – At a high level how does it works?
(Vadivel) One of the excellent feature introduced in SQL Server 2016 is “Always Encrypted”. This gives an extra layer of production as no one (including the production DBA’s) will be able to access the actual data without having the appropriate key.
SQL Server 2016 Exec Query Stats DMV Enhancements
(Ahmad Yaseen) I noticed that in SQL Server 2016 the system catalog view sys.dm_exec_query_stats has many new columns. What are these and how they be used?
Checking DBCC CHECKDB
(Arun Sirpal) I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to. For this post I want to show you how you can check whether or not CHECKDB has been successfully executed.
Point in Time Recovery with SQL Server
(Dinesh Asanka) How often are you working with multiple environments? For example, if you are a database administrator who is responsible for a production environment as well as another environment, it most likely that you will be working with both environments simultaneously.
SQL Server Identity Values Check on GitHub
(Thomas LaRock) Last year I blogged about a script that Karen López (blog | @datachick) and I wrote together to help you determine if you were running out of identity values.
Power BI on-Premises Production Targeted for Mid 2017
(Paul Turley) NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted for mid 2017. This is much sooner than most folks in the community were anticipating. An installable technical preview is targeted for January of 2017.