Database Nonsense - Unstructured Data
Sloppy terminology leads to big misunderstandings. Terms don't get much sloppier than "Unstructured data".
2016-10-25
589 reads
Articles
Managing Registered servers with SQL Powershell
Learn how to generate Registered Servers with PowerShell in this article.
2016-10-25
5,463 reads
Master Data Services – The Basics
Master Data Services (MDS) is Microsoft's platform for supporting Master Data Management (MDM). A system like MDS, if properly maintained, gives organisations a powerful alternative to increasingly having to centralize databases as a way of preventing data from getting out sync or become inconsistent, and a reliable way of managing the flow of data through corporate IT systems. It makes microservice architectures realistic. Hari Yadav shows you how to get up and running with MDS.
2016-10-25
4,165 reads
The Sort that Spills to Level 15,000
Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations.
2016-10-24
3,412 reads
JSON Select - Easily query values from JSON
Introducing JSON Select - a new library that makes it easy to pull values out of JSON strings in SQL Server 2005+
2016-10-21 (first published: 2015-08-31)
13,509 reads
Memory/Storage Technology Hierarchy and SQL Server
Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.
2016-10-21
5,279 reads
Basic Data Manipulation for Relational Data in R
In this post I will attempt to explore simple commands to manipulate data pulled in from a SQL database into R.
2016-10-20
1,663 reads
Getting started with Query Store feature in SQL Server 2016 – Part 3
Arshad Ali demonstrates how you can analyze the data collected by Query Store either with T-SQL scripting or with the graphical user interface in SSMS.
2016-10-20
4,404 reads
PowerShell Just Enough Administration
A major difficulty for a System Administrator who wishes to provide access for auditors, Helpdesk staff, developers and other IT people is that adminstrator roles give users more access than they need. It is too easy to make mistakes, or to make more changes than those that were signed-off. With JEA, it is possible to create role-based access control (RBAC) endpoints that define precisely what actions you’ll let your users carry out without needing a elevated, privileged administrator credentials, and which log and report all operations.
2016-10-19
3,276 reads
Automatically upload SQL Server Database Backups to Azure with Integration Services
Daniel Calbimonte shows how the Feature pack in SQL Server Integration Services can connect to Azure to automatically copy your SQL Server database backups.
2016-10-18
4,153 reads
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 Kalimalang Telpon/WA:08213111185
BCA KCP Kalimalang Telpon/WA:08213111185 Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D,...
BCA KCU MATRAMAN Telpon/WA:08213111185
BCA KCU MATRAMAN Telpon/WA:08213111185 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota...
BCA KCP Pasar Legi. Tlp/wa:082372744391
Jl. Letjen S. Parman No.135, Kestalan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah 57133
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