(Andrew Reid) In Oracle 9 you got an error if you tried to rename a tablespace:
Author: SSWUG Research
DBMS_PREDICTIVE_ANALYTICS & Predict
(Brendan Tierney) In this blog post I will look at the PREDICT procedure that is part of the DBMS_PREDICTIVE_ANALTYICS package. This package allows you to perform data mining in an automated way without having to go through the steps of building, testing and scoring data.
Geek City: SQL Server 2014 In-Memory OLTP (‘Hekaton’) Whitepaper
(Kalen Delaney) Tech Ed isn’t even over yet, and my new Hekaton Whitepaper is already generating questions I can’t answer yet!
SSWUGtv: Are system administrators really a thing of the past…or are they still relevant? Find out with Steve today!
Video Programming for IT Professionals
Using Policy Based Management to check number of SQL Server data and log files
(Svetlana Golovko) To meet our database configuration standards we want to make sure that we have only one database transaction log file and more than one data file. In this tip we look at how this can be done using a policy.
SSRS Production Deployment, Part 1
(Ivan Krivyakov) So, you built your shiny and flashy SSRS report, and you hit “Deploy” in BIDS, or “SQL Server Data Tools” in newer versions. Your UAT is a breeze, and everything looks great.
Performance characteristics of IBM InfoSphere Information Server 8.7 running on VMware vSphere 5.0 on Intel Xeon Processors
(Samuel Wong, Jantz Tran and Pin Lp Lv) With the continuous growth of processing power and the increasing number of processor cores in servers, virtualization has become very attractive for many companies. As more and more IBM InfoSphere Information Server customers begin to adopt virtualization tec
Bulk insert into tables in sorted order to avoid deadlocks
(Justin Swanhart) Shard-Query inserts data into a “coordinator” table when answering queries. When there is a GROUP BY on the original query, the coordinator table contains a UNIQUE KEY over the GROUP BY attributes. Shard-Query uses INSERT .. ON DUPLICATE KEY UPDATE in combination with bulk inse
SQL SERVER – Script to Update a Specific Column in Entire Database
(Pinal Dave) Last week, I have received a very interesting question and I find in email and I really liked the question as I had to play around with SQL Script for a while to come up with the answer he was looking for. Please read the question and I believe that all of us face this kind of situation
Len() and DataLength()
(John Huang) Both system functions, Len() and DataLength(), in SQL Server are used to measure the length of the data. The main difference of those 2 is that Len() gets the string length of the data in which DataLength measures the storage length of the data.