More Regulation Coming?
With no end to company hack attacks in sight, will we get new regulation instead?
Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
How do you use change scripts for your database deployments?
Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.
Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
Five Minute Refactoring
The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.
The Challenges of Space
CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.
Powershell day-to-day Admin tasks: WMI, CIM and PSWA
WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.
Stored Procedures and SQL Injection
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
Managing Test Data as a Database CI Component - Part 2
Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Bank BCA KCU Singaraja Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jalan Dokter Sutomo No.3, Banjar Bali, Kec. Buleleng, Kabupaten...
Bank BCA KCU Kuta Telp/Wa:0817 839 777
Bantuan CS : (0817) 839777 Jl. Sunset Road No.88B, Kuta, Kec. Kuta, Kabupaten Badung,...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers