SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
281 reads
Contextual View Part II or how to hide sensitive data
In this article I continue to explore the ways to secure the data via contextual views and describe the technique...
2018-10-18
556 reads
Step-by-Step: How to Trigger an Email Alert from Windows Performance Monitor
Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of...
2018-10-18
1,677 reads
Pagination pattern or how to fetch a large dataset for a web report.
In this post we will discuss how to fetch data from a large dataset for web applications using pagination technique....
2018-10-17
433 reads
Fix SQL Server with one click
Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration...
2018-10-17
307 reads
Invalid value given for parameter PASSWORD. Specify a valid parameter value.
I still use sp_help_revlogin to transfer logins between servers. I know there are other options, including a set of Powershell...
2018-10-30 (first published: 2018-10-17)
7,799 reads
What is the Object Explorer Details tab good for?
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL...
2018-10-17
292 reads
How to Start Speaking
At the last few events I attended, I’ve gotten into conversations on how to begin as a speaker. So I...
2018-10-17
347 reads
2018-10-17
210 reads
Lookup. Foreign Key Constraint vs Check Constraint
This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data...
2018-10-16
469 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...
Alamat BCA KCP Mangunsarkoro Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mangunsarkoro No.24, Pamoyanan, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43211
Alamat BCA KCU CIANJUR Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
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