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.
I have a seen a serious performance dive when moving from SQL2008R2 to SQL2012 on my linked server queries. I have set the linked server on the SQL2012 ...
Hi all, i'm by no means an SSAS pro so if I should be doing something differently please let me know. I have my cube dsv ![alt text]
I have my dimensions... ...
We are implementing a Disaster recovery server for our live database server. What naming convention can be used for this DR Server. For example, ...
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you have a failed SQL Server job.
Here is our ...
In the last article I introduced a power tool that can be used to help manage Extended Events. That tool is PowerShell. In that article, I focused primarily ...
I am stuck in stored procedure where I need some help. I have a procedure in which it tells me how many month or week or day it has been within two dates ...
I am getting following error from My clients
My Server is using SQL 2008 R2. We have recently migrated from SQL 2005.
Database Compatiblity is ...
In our organization We run a job every hour that drops and recreate the snapshot of a database. We didn't face any issue till yesterday. But ...
Hello All, we are new to Amazon Redshift and we are planning to migrate the data(procs,cubes etc) from sql server to Redshift. I have gone through some ...
SELECT INV_NUM, CUST_NUM, CUST_LNAME, CUST_FNAME, INV_DATE, INV_AMOUNT
FROM CH08_INVOICE i
INNER JOIN ...
[link text]I will execute below step1 script.
Created Table with identity column
Insert one record, ...
Is it worth supporting older software? Steve Jones has a few thoughts.
In this level of the Stairway to Server Virtualization, learn how to build a Hyper-V virtual machine for SQL Server.
In this follow-up to a previous article, Aaron Bertrand reiterates that - while you should never just accept the defaults - you really should think about ...
Between 26th and 28th of May 2016, we (TUGA Association) are organising a major IT event in Portugal – TUGA IT. Targeting Microsoft Data Platform, ...
Unless you have been sleeping under the rock in the past 5 days, if you are a twitter user, you should have definitely seen some of the reactions and ...
My Session: Using Azure SQL Database for Enterprise Needs
On 10/6/2015, I presented on Azure SQL Database at TechFuse Minnesota. Some of the highlights ...
I need to attach a file for each result in a query, could be a single result could be 10. Using Microsoft SQL server 2012.
example: `select ItemNumber ...
Please suggest how can we achieve below scenario if possible.
DECLARE @PRODUCT TABLE
[Base Part] VARCHAR (50),
Wanted to know if I can have two ssrs instances on the same server, one in native mode and one in sharepoint ...
I’ve been on a testing kick, trying to formalize the ad hoc queries I’ve run into something that’s easier to track. As a result, when ...
There was a question raised some time back 'If an index is not selective, will the query operators that use it always be index scans'?
It's an interesting ...
how to convert excel version by xlsx to xls by using SSIS/SSRS.
how to skip the data load to the top five records in excel by using SSIS.
I have a CRM app that i've build and this is my biggest query in there. this tables have about 50k-100k rows each and to join all of them and order by ...
October 4th of this month was my seven year anniversary as an employee of Pragmatic Works. Things have changed a lot over the past seven years. Working ...
Register here. In our monthly series about Minion Enterprise – the new SQL Server management solution – Sean and Jen will show you how “ME” ...
My article "SSIS Design Pattern - Staging Fixed Width Flat Files" is published on SQLServerCentral.com. In the article, I provide a design pattern for ...
So far in this series I have introduced a couple of tools that are suitable for helping with the management of Extended Events. The tools introduced so ...
Here is an overview of the articles I published in the third quarter of 2015.
Retrieve file sizes from the file system using Power Query
Create a Treemap ...
Hi GuysJust encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the synopsis of challenge ...
Steve looks at the temporal table feature that's coming in SQL Server 2016.
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
Minion Enterprise can help you with security management in an enterprise.
Automatic UNDO Management isn't voodoo or black magic, although it can seem that way when it isn't clearly understood. How does Oracle decide how many ...
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient ...
Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It's ...
One of the ways that you take more direct control over your SQL Server instances is through the use of trace flags. There are a number that people recommend ...