Security Through Chaos
A company Steve Jones knows uses a diverse network infrastructure to help provide security.
Schema-Based Access Control for SQL Server Databases
Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.
Data Mining Part 26: Introduction to Cubes
In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.
Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image
There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.
Sweeping out SQL Server 2005
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
How to Get SQL Server Data Conversion Horribly Wrong
One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary. These boil down to seven ways of failing to get data conversion right. Rob Sheldon explains and gives sage advice on how to avoid the problems.
How DBAs Can Adopt the Craftsman Mindset
The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they get at the work, the more enjoyable the work gets, and the more successful they become. Deliberate practice, Specialization and an appetite for overcoming difficulty are good habits to deliberately adopt to successfully grow those craftsmanlike skills to the point that you become “so good they can’t ignore you”.
How to Categorize Uncategorized Data
Using SQL to perform cluster analysis to gain insight into data with unknown groups
QA for Data
Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.
Selecting Data Using the TOP Clause
There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Pasar Legi NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Letjen S. Parman No.135, Kestalan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah...
BCA KCP Palur NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa...
Cara reschedule tiket Garuda Indonesia
Untuk reschedule tiket Garuda Indonesia Anda dapat menghubungi saluran resmi Garuda di 0823-2461-4949 Atau...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers