 | A community of more than 1,600,000 database professionals and growing |
| | | Faster Cloud Warehouses I think the cloud is a perfect place for a data warehouse. In many organizations, I've found that a data warehouse system is often the largest SQL Server database, both in size of database and also in terms of resources allocated. These systems often handle many complex queries for business users and are allocated a large number of CPUs as well as lots of RAM. Even then, many ad hoc BI tools or lots of "what-if" queries can bring the system to its knees, often causing lots of stress for database administrators during the periods of time when the system is in heavy use. Fortunately, many of these systems aren't in use all the time. Often these are systems used by financial departments to "close the books" at month, quarter, or year end. It's at these times when lots of resources are needed. Outside of these times, the data warehouse might be one of the least used systems, which makes it a perfect choice for a cloud, scale on demand, environment. Scale up when needed, down when not, limit your costs to the resources you need, when you need them. Microsoft has increased the capabilities of the Azure SQL Data Warehouse quite a few times across the last few years. I was thrilled to see ASDW separate out storage from compute, allowing customers to scale up the query, or compute, nodes independently of the storage used. Changes last year improved the ability to move data around between compute nodes as well as increased the number of concurrent queries. These improvements are perfect for data warehouses, and if you are looking to build a more responsive SQL Server based warehouse, you ought to take a look at ASDW. More and more customers are finding it valuable and cost effective in their businesses. What seemed to once be a niche idea has grown into a business that quite a few customers are using, with the demand growing. What's more, the move to Big Data Clusters in SQL Server 2019 seems to have adapting some of this technology to the regular SQL Server product many of us use. These will separate out the storage from compute, something that should help many of us scale our systems to meet the demand of our workloads. I haven't tried a big data cluster yet, but I'm looking forward to seeing how well one works and if it truly scales SQL Server further than I would have dreamed. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.6MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | |  | | How SQL Server monitoring benefits your whole organization SQL Server monitoring doesn’t just benefit your DBAs. In this new guide from Redgate, we take you through the different ways a robust monitoring solution has a positive impact across your organization, from your development teams to IT management, and from finance to your C-suite. Download your free copy now |
|
|
|
| | |
 | Press Release from Redgate If a query is performing poorly, and you can't understand why, then that query's execution plan will tell you not only what data set is coming back, but also what SQL Server did, and in what order, to get that data. It will reveal how the data was retrieved, and from which tables and indexes, what types of joins were used, at what point filtering, sorting and aggregation occurred, and a whole lot more. These details will often highlight the likely source of any problem. More » |
 | Additional Articles from MSSQLTips.com In this tip we look at how you can use DAX formulas within your SQL Server Reporting Services Report Builder reports. More » |
 | Gavin Draper from SQLServerCentral Blogs A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index.... More » |
| | Grant Fritchey from SQLServerCentral Blogs I’ve been reading about the death of the DBA ever since I first made the jump from full time developer... More » |
|
|
| | | Today's Question (by Steve Jones): I am working in Python and have two lists: >>> West = ["Broncos", "Chiefs", "Chargers", "Raiders"] >>> South = ["Texans", "Titans", "Colts", "Jaguars"] >>> North=["Ravens", "Steelers", "Browns", "Bengals"] I now decide to run this code. What is the value of Teams? Teams = West + South + North |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Python. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| | Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a SQL Server 2016 instance on Windows and want to enable the buffer pool extension option on my instance. How do I do this?
Answer: Use ALTER SERVER CONFIGURATION to turn this on and set the file Explanation: The Buffer Pool Extension option is enabled with ALTER SERVER CONFIGURATION. Ref: ALTER SERVER CONFIGURATION - click here
» Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
sp_help_revlogin missing - We have a 2017 install that was set up as windows auth. We recently decided to use mixed mode instead... Profile Trace prior to upgrading 2008 - 2017 - Hi I am looking for a tool that can look at a profile trace file of a 2008 server's activity and...
Is sp_send_dbmail Asynchronous? - Hopefully this is an easy question. In my scenario, I want some events to trigger an e-mail to someone. I have... Match vertical records to next greater date to find datediff - I need to find the amount of time a user spent watching videos. I have play/pause actions recorded with time...
Creating a subset of data - Thanks for reading and hopefully helping me find a solution... I have a database that is about 750GB and i would... centraldb by Crazydba - Hi Anyone knows the link to download CentralDB newest version. It used to be at crazydba.com, but the size is not...
Determining a Start Date within a subset of a group - I have a result set that I need to apply grouping within. However, the grouping is not just a simply...
Databses with >40,000 Users - Hello. Has anybody come across any issues with large numbers of Users in a database - i.e. >40,000. We hit 32767 Users some... Import many databases - Hi, I have 100 databases, with 1000 table each database (all databases= 5 TB). What is the most simple method to import...
very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all. Update trigger - I have insert trigger for inserting records from T_PDF table into T_WV_RESULT Table. The below trigger is fired when new records are inserted...
Replication error - Hi Team, I have an issue with replication, the log reader always gives this error: The process could not execute 'sp_MSadd_replcmds' The database... Performance ISSUE in 2012 - Hi experts , I am getting the following error in production environment. [Msg 8623, Level 16, State 1, Line 1 The query processor...
conversion from Excel format date to sql date functon - I have create_date stored in sql server table in excel format with function =DATE(1980,1,1+A1-722815). I need to convert this into... Dynamic query parameter conversion - Hi I'm trying to execute a dynamic query which takes (or should take) a bigint value to filter the results. Essentially the query...
Query tuning with conditional aggregation - Hi all, I have a stored procedure that returns a table 1Million + rows that I then need to pivot (I can't... View timeout problem - I have a fairly complex sql view that times out most of the time. I run it from SSMS to... Date functions.. - i was trying to solve an online test... and i stopped here... i tried looking at the newly introduced functions...
SSIS, FlatFile Destination with Multiple record types and formats - Hello all, I have a requirement to create a flat file for a one of our vendors that has fixed length... How can execution of SSIS Package be stopped after a certain task executes? - QUESTION : HOW CAN I MAKE THE PACKAGE STOP right after sending mail task? So if mail is sent on the specified... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
