Solve Common SQL Server Restore Issues
Understanding backup and restore processes is essential for developers and DBAs to be more confident when dealing with uncommon situations and having the ability to suggest flexible solutions related to these processes. In this article, Sergey Gigoyan answers some key questions relating to backup and restore.
Declarative SQL: Using UNIQUE Constraints
In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. In this introduction to Declarative SQL, Joe Celko demonstrates how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.
Security Decisions
This week Steve Jones looks at how we make secutiy decisions for our systems, and whether this is really the best way to do things.
Exploration of SQL Server 2016 Always Encrypted – Part 1
With the introduction of SQL Server 2016 you now have a new way to encrypt columns called Always Encrypted. With Always Encrypted, data is encrypted at the application layer via ADO.NET. This means you can encrypt your confidential data with your .NET application prior to the data being sent across the network to SQL Server. In this article, Greg Larson explains his experience with exploring setting up a table that stores always encrypted data.
Convert Rows into Columns
Convert the rows of a SELECT statement into a predetermined number of columns.
How Much Eventual Consistency Do You Have?
This week Steve Jones wants to know if you have eventual consistency in your environment?
Integrating Big Data Applications into Operational Environments
Integrating big data appliance solutions into a data warehouse requires preparation and forethought. DBAs and business data consumers must work together both to address the implementation issues above and to meet the needs of multiple business data consumers. Lockwood Lyon discusses the topic.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Cilegon Telpon. 08388331767
WhatsApp 08388331767 Jl. Raya Merak No.42, Ramanuju, Kec. Purwakarta, Kota Cilegon, DKI Jakarta 42411
BCA KCP Duta Mas Fatmawati Tlp (+62 821°3111°179
Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No. 6, 7,...
BCA KCP Klungkung Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Puputan No.88 B, Semarapura Kelod, Kec. Klungkung, Kabupaten Klungkung, Bali 80716
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers