Here at Database Weekly, we scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week. Here, we have an assortment of the latest articles from selected sources.

At DatabaseWeekly.com you can sign up for the newsletter and browse the latest news.

Latest Articles


SQLServerCentral - Questions
This issue was brought to my attention today. When returning a value from an Oracle database via a ...
23:20 06-Jul-2015
SQLServerCentral - Questions
I tried using this syntax alter table [Person].[Phonenumber] add column_name BusinessEntityID INT NOT NULL and got the error Msg 102, Level 15, State ...
20:56 06-Jul-2015
SQLServerCentral - Blogs
Continuing on with my Partitioning post series, this is part 5. The partitioning includes several major components of work (and can be linked below); partitioning ...
20:30 06-Jul-2015
SQLServerCentral - Questions
What is the difference between Build, Deploy and Process commands for an SSAS cube? Is there a specific order to these commands?
18:08 06-Jul-2015
DatabaseWeekly - Newsletter
Sometimes, while searching the root cause of database problems, we face page IDs and need to find to which object that page belongs. We can find this ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
I am often invited to attend various interviews and once in a while, I see practical questions discussed ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
by Martin Doyle Data exists in a dangerous state of near-non existence. Few businesses would risk not having backups in place. With cloud computing becoming ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
I love keyboard shortcuts. I'd rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won't use the mouse, but only when ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
A new encryption technique, which is similar to techniques already used to process big data, could also for more secure and hopefully better analytics. ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
I frequently see statements on forums along the lines of "I don't have a test server, so I'm going to do something I've never done before directly on my ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
In December of 1974, Communications of the ACM magazine published Computer Programing as an Art by Donald Knuth. In it, Knuth wrote these now famous words: The ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
Originally posted on: http://tostringtheory.com/darrengosbell/archive/2015/06/24/announcing-dax-studio-2.2.0.aspxToday we released DAX Studio 2.2 which ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
You know that you can add data to a table using VALUES clause. But did you know that you can create ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
You can download the latest version of ClearTrace from my consulting site: scaleSQL Consulting.  I've decided to stop using the year as part of the version.  ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
by Angela Guess Joanna Schloss of IT Pro Portal recently wrote, "For big data, the day after tomorrow is here. Gone are the days of CIOs and CMOs talking ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
Database Console Command CHECKDB (DBCC CHECKDB)is used to check the integrity (physical & logical) of objects in a SQL Server database.The command is ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
In Oracle and the NoSQL Effect, Robin Schumacher (RS), a former "data god" DBA and MySQL executive now working for a NoSQL vendor claims that Oracle's ...
16:47 06-Jul-2015
DatabaseWeekly - Newsletter
You're working with SQL Server, and you really want to learn how to make it faster and more reliable, but your boss just won't let you go off to our upcoming ...
16:47 06-Jul-2015
SQLServerCentral - Blogs
The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and ...
15:34 06-Jul-2015
SQLServerCentral - Questions
Hi, I've been using several role playing dimensions for my cube. One for "Sales Turnover", "Sales date", "Inventory turnover", etc. There is a fact table ...
14:10 06-Jul-2015
SQLServerCentral - Blogs
I frequently see statements on forums along the lines of “I don’t have a test server, so I’m going to do something I’ve never ...
11:49 06-Jul-2015
SQLServerCentral - Blogs
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made ...
11:47 06-Jul-2015
SQLServerCentral - Blogs
I love keyboard shortcuts. I’d rather keep my hands on the keyboard than move back and forth to the mouse. Not that I won’t use the mouse, ...
11:00 06-Jul-2015
SQLServerCentral - Questions
Hi guys, I need your help on this. I have an SQL Server that I use for reporting. Every morning at 4:45am, I have a job that loads data from my LIVE ERP ...
10:05 06-Jul-2015
Simple-Talk - Blogs
Sometimes, while searching the root cause of database problems, we face page IDs and need to find to which object that page belongs. We can find this ...
07:49 06-Jul-2015
SQLServerCentral - Questions
Hello, I am looking for some good tools (specially Freeware) which shows the SQL server code/script followed best practices, and also highlight syntax ...
06:11 06-Jul-2015
SQLServerCentral - Editorials
Something sufficiently complex, in our eyes, may appear to be magic. Steve Jones feels some of his knowledge about SQL Server looks the same way to others. ...
23:00 05-Jul-2015
SQLServerCentral - Main Articles
Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms
23:00 05-Jul-2015
SQLServerCentral - Main Articles
Learn about the new temporal table feature in SQL Server 2016
23:00 05-Jul-2015
SQLServerCentral - Main Articles
It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a ...
23:00 05-Jul-2015
SQLServerCentral - Blogs
Continuation from the previous 57 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have previously blogged on the predicate ...
21:24 05-Jul-2015
SQLServerCentral - Questions
set doj='06-jan2015' here date is written in single quotes bt we write varchar data type in single quotes, ...
07:50 05-Jul-2015
SQLServerCentral - Questions
I am having a bit of trouble trying to import a datetime field from MS Access into SQL Server 2005 database. The ...
04:42 05-Jul-2015
SQLServerCentral - Questions
With names of Grant Fritchey, Kev Riley and few others, one can see "two diamonds" after the name, whereas, with names of ThomasRushton, Dave_Green and ...
04:15 05-Jul-2015
SQLServerCentral - Blogs
Today, the 3rd of July 2015 marks the 2rd anniversary of my very first Columnstore Indexes blog post in the series that is going strong for 60 different ...
02:38 05-Jul-2015
SQLServerCentral - Questions
I created a dataflow task which has a source oledb connection to Oracle and a destination oledb to SQL ...
13:25 04-Jul-2015