Experimenting SysTools SQL Database Repair Tool by SQL MVP Shashank
Author Bio: Shashank is a TechNet Wiki Ninja who loves to work on SQL Server. He lives in Mumbai and...
2018-08-24
361 reads
Blog Posts
Identifying records with special characters (Unicode)
Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the...
2018-08-24 (first published: 2018-08-07)
8,207 reads
Leveraging on SQL Server metadata
I’m working on a project where I need to convert Firebird SQL code into T-SQL code.
No schema, just the modules....
2018-08-24
325 reads
Warning: Expect Delays
Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...
2018-08-24 (first published: 2018-08-12)
2,042 reads
Azure Runbook Configuration
Hello everybody! Greetings from the very warm state of Texas! One of the most popular questions I get when talking...
2018-08-23 (first published: 2018-08-02)
2,118 reads
Exporting Extended Events Session Data to a Table
If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...
2018-08-23 (first published: 2018-08-08)
2,374 reads
Guatemala SQL Server local group
Good news for all the Guatemalan data professionals, starting from August 2018 you have an official PASS SQL Server local...
2018-08-23
305 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
346 reads
PSPowerHour v1.0 Wrap-Up
The first edition of the PSPowerHour is in the books and it looks like it was a big success. This one was dbatools-heavy but I chalk that up to...
2018-08-23
19 reads
Always On SQL Server Replica in a Disconnected State
Sometimes the SQL logs and application logs provide some great info in regards to errors and issues. When building an...
2018-08-22
5,804 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