AG without WSFC SQL 2017 and more…
Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has...
2019-11-11
57 reads
Last Week Reading (2019-11-10)
Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....
2019-11-10
21 reads
Wrangling data flows in Azure Data Factory: Calculating distance between two Geo-points
(2019-Nov-10) Microsoft has recently announced a public preview of the Wrangling data flows in Azure Data Factory (ADF). What used to be called Power Query in Excel, Query Editor in Power...
2019-11-19 (first published: 2019-11-10)
2,079 reads
MAXDOP and Tempdb – SQL 2016
Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication...
2019-11-09
198 reads
Omaha Azure User Group Presentation Nov 18
I’m happy to announce that I’ll be presenting an in-person session for Omaha’s Azure Users Group on Monday, November 18 at 3:00pm, entitled “SQL Server in the Microsoft Cloud“....
2019-11-09
31 reads
Rounding Out PASS Summit 2019
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
483 reads
Focusing on Business Value
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
247 reads
What SQL Server Agent Alerts Do I have setup?
I am in a situation where I have to incorporate SQL Server Agent alerts in my monitoring and alerting strategy.I needed a query (DMV) to get details on what...
2019-11-18 (first published: 2019-11-07)
683 reads
Finding out the most cached database in the buffer cache - The DMV Way
While there are many ways and criteria to find out what database is the most used, under optimized, trouble maker etc....., here is one more to find out the...
2019-11-07
207 reads
Pass Summit 2019 Keynote Day 2
I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading
2019-11-07
112 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers