databasesarefun.blogspot.com databasesarefun.blogspot.com

databasesarefun.blogspot.com

Databases Are Fun

Monday, September 25, 2017. Automatically scaling up and down between pricing tiers in Azure SQL databases. We want a certain level of performance for our Azure databases, but sometimes we don't need that performance 24/7. And if we don't need it, we don't want to pay for it! This is currently running with SQLCMD on a VM, but we'll probably switch to Azure Automation eventually. Note that you use this code at your own risk! ScaleUpServiceObjective End else if @ScalingMode = 'ScaleDown' Begin Update @Pric...

http://databasesarefun.blogspot.com/

WEBSITE DETAILS
SEO
PAGES
SIMILAR SITES

TRAFFIC RANK FOR DATABASESAREFUN.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 15 reviews
5 star
9
4 star
4
3 star
1
2 star
0
1 star
1

Hey there! Start your review of databasesarefun.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

Desktop Preview Tablet Preview Mobile Preview

LOAD TIME

0.8 seconds

CONTACTS AT DATABASESAREFUN.BLOGSPOT.COM

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

SCORE

6.2

PAGE TITLE
Databases Are Fun | databasesarefun.blogspot.com Reviews
<META>
DESCRIPTION
Monday, September 25, 2017. Automatically scaling up and down between pricing tiers in Azure SQL databases. We want a certain level of performance for our Azure databases, but sometimes we don't need that performance 24/7. And if we don't need it, we don't want to pay for it! This is currently running with SQLCMD on a VM, but we'll probably switch to Azure Automation eventually. Note that you use this code at your own risk! ScaleUpServiceObjective End else if @ScalingMode = 'ScaleDown' Begin Update @Pric...
<META>
KEYWORDS
1 databases are fun
2 posted by
3 sylvia m v
4 no comments
5 product id and
6 why is it
7 isafterhours
8 convert bit
9 case
10 isbusinesshours
CONTENT
Page content here
KEYWORDS ON
PAGE
databases are fun,posted by,sylvia m v,no comments,product id and,why is it,isafterhours,convert bit,case,isbusinesshours,else null,here's the trigger,workaround,older posts,links,blog archive,october,about me
SERVER
GSE
CONTENT-TYPE
utf-8
GOOGLE PREVIEW

Databases Are Fun | databasesarefun.blogspot.com Reviews

https://databasesarefun.blogspot.com

Monday, September 25, 2017. Automatically scaling up and down between pricing tiers in Azure SQL databases. We want a certain level of performance for our Azure databases, but sometimes we don't need that performance 24/7. And if we don't need it, we don't want to pay for it! This is currently running with SQLCMD on a VM, but we'll probably switch to Azure Automation eventually. Note that you use this code at your own risk! ScaleUpServiceObjective End else if @ScalingMode = 'ScaleDown' Begin Update @Pric...

INTERNAL PAGES

databasesarefun.blogspot.com databasesarefun.blogspot.com
1

Databases Are Fun: June 2011

http://databasesarefun.blogspot.com/2011_06_01_archive.html

Wednesday, June 1, 2011. Masking PII (Personally Identifiable Information). Privacy has been an increasing concern in information technology, and many companies have policies in place that prevent data that could identify a person from being easily accessed. This data is called PII (Personally Identifiable Information). Laws like HIPAA (Health Insurance Portability and Accountability Act) in particular are restrictive of how PII data can be accessed. The script currently runs all the updates in one chunk...

2

Databases Are Fun: May 2014

http://databasesarefun.blogspot.com/2014_05_01_archive.html

Friday, May 16, 2014. How to search for a string in your SQL Server database code. EDIT May 27, 2014: Forget this! Really, just forget it and use the Red Gate SQL Search tool. I just downloaded it and have been using it all morning. It's free, functional, searches EVERYTHING at the same time (job steps, tables, columns, etc), and has a very usable interface. This will replace ALL of my queries against system objects. A huge bonus with this query is the XML field that contains the definition. When you...

3

Databases Are Fun: Troubleshooting slow SQL Server stored procedures - using the Modulo function to improve productivity

http://databasesarefun.blogspot.com/2014/09/troubleshooting-slow-sql-server-stored.html

Monday, September 8, 2014. Troubleshooting slow SQL Server stored procedures - using the Modulo function to improve productivity. Recently I needed to create a stored procedure to process and cleanse a huge set of call center data on a daily basis - more than half a million calls a day. And because data could be backed up and unavailable at times, sometimes a run of multiple days would be necessary, so many millions of rows. So, how to speed up the procedure and get rid of all those inefficient breaks?

4

Databases Are Fun: Microsoft SQL Server online documentation is improving

http://databasesarefun.blogspot.com/2014/08/microsoft-sql-server-online.html

Sunday, August 17, 2014. Microsoft SQL Server online documentation is improving. Previously, when I was looking for quick information concerning syntax or other SQL Server details, I avoided the Microsoft SQL Server online documentation. Why? Because it was far too difficult to extract the information you needed from the gobs and gobs of text, with every possible variation of every single parameter. Check out this page. Did you notice that there's 764 lines on the page? So, Microsoft documentation has be...

5

Databases Are Fun: August 2014

http://databasesarefun.blogspot.com/2014_08_01_archive.html

Sunday, August 17, 2014. Microsoft SQL Server online documentation is improving. Previously, when I was looking for quick information concerning syntax or other SQL Server details, I avoided the Microsoft SQL Server online documentation. Why? Because it was far too difficult to extract the information you needed from the gobs and gobs of text, with every possible variation of every single parameter. Check out this page. Did you notice that there's 764 lines on the page? So, Microsoft documentation has be...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

databasesandlife.com databasesandlife.com

Databases & Life

My name is Adrian Smith. I am a software developer, software architect and performance consultant. Originally from the UK, working in Vienna since 1998. These days I mainly work on web software using Java. This is my blog, where I write about topics such as: software architecture. And, ocassionally, my life. On writing deadlock-free and composable software. On writing deadlock-free and composable software (4 Feb 2018). Unit testing code that needs data in a database (12 Apr 2017). More content: All posts.

databasesandlists.com databasesandlists.com

RSA LISTS Executive email lists, Databases and Lists

databasesandmore.com databasesandmore.com

Search, Register and Transfer Web Domain Names and More

Delegate} logged in as: {firstName} {lastName}. Delegate} logged in as: {firstName} {lastName}. 24/7 Sales and Support (480) 624-2500. DOMAIN NAMES ▼. WEB HOSTING ▼. SSL and SECURITY ▼. EMAIL ACCOUNTS ▼. MARKETING TOOLS ▼. BUILD A WEBSITE ▼. Check My Web Mail. From only $19.99/yr. Get your own .ME and use the built-in tool kit to launch a site that brings all your online activities to one spot. Tell me more. From only $1.99/mo! Fast, reliable, private, secure and spam-free! From only $9.99/yr! Use of thi...

databasesarang.net databasesarang.net

databasesarang.net

databasesarefun.blogspot.com databasesarefun.blogspot.com

Databases Are Fun

Monday, September 25, 2017. Automatically scaling up and down between pricing tiers in Azure SQL databases. We want a certain level of performance for our Azure databases, but sometimes we don't need that performance 24/7. And if we don't need it, we don't want to pay for it! This is currently running with SQLCMD on a VM, but we'll probably switch to Azure Automation eventually. Note that you use this code at your own risk! ScaleUpServiceObjective End else if @ScalingMode = 'ScaleDown' Begin Update @Pric...

databasesavvy.com databasesavvy.com

databaseSavvy.com

We're Database Savvy! We are currently building a new site which will be ready soon. In the mean time you can follow us via our email newsletter to stay updated on our progress. Site will launch in. Sign up for our newsletter.

databasesb2b.com databasesb2b.com

Home page

Business Databases by Country. You have no items in your shopping cart.

databasesbuddy.com databasesbuddy.com

Price Request - BuyDomains

Url=' escape(document.location.href) , 'Chat367233609785093432', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=640,height=500');return false;". Need a price instantly? Just give us a call. Toll Free in the U.S. We can give you the price over the phone, help you with the purchase process, and answer any questions. Get a price in less than 24 hours. Fill out the form below. One of our domain experts will have a price to you within 24 business hours. United States of America.

databasesbydesign.co.nz databasesbydesign.co.nz

Databases By Design - Home

Remote support tool - TeamViewer. We now use Team Viewer for remote desktop support. This tool is extremely easy to install and does not require any firewall changes to use. Clients of Databases by Design can download the free host utility TeamViewer QuickSupport. And immediately get a connection and desktop support. TeamViewer has a audio option as well for those clients with microphone and speakers. View more info on TeamViewer here. We hope to send the logon information by email by the end of August.

databasesbydesign.com databasesbydesign.com

Price Request - BuyDomains

Url=' escape(document.location.href) , 'Chat367233609785093432', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=640,height=500');return false;". Need a price instantly? Just give us a call. Toll Free in the U.S. We can give you the price over the phone, help you with the purchase process, and answer any questions. Get a price in less than 24 hours. Fill out the form below. One of our domain experts will have a price to you within 24 business hours. United States of America.