Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
Data Mining: Part 13 Powershell
In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.
The Brittleness of Replication
Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.
Adding Custom Reports to SQL Server Management Studio
In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.
SQL Saturday #320 - Raleigh, NC
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group (http://www.tripass.org) of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.
Data is Not Always Enough
More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.
Verify SQL Backup Integrity
Perform automated database restores and check the integrity of your backup files
We Don't Care about Data and IT Security
Most of us say we care about IT and data security. Our actions speak differently.
Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups
In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.
How to Create a Corrupt SQL Server Database
This article details how to create a corrupt SQL Server database for testing purposes
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Alamat BCA KCP Ampera Telp/Wa (+62) 821-8200-233
Call Cs 08218200233 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu,...
Alamat BCA KCP Ambasador Telp/Wa (+62) 821-8200-203
Call CS 08218200203 Mal & Apartemen Ambasador, Jl. Prof. DR. Satrio No.R.18 Lt Dasar,...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers