Getting Started with SQL Server on Google Cloud Platform
Learn how you can create a SQL Server instance in the Google Cloud Platform.
2019-09-26
2,608 reads
cloud services
Fixing Performance By Throwing Cloud At It
Your databases are hosted in the cloud – either in VMs or in a database-as-a-service – and you’re having a performance emergency that’s lasted for more than a day. Queries are slow, customers are getting frustrated, and you’re just not able to get a fix in quickly. Just ask management if they want to throw hardware at it.
2019-05-10
Processing Data Using Azure Data Lake, Azure Data Analytics, and Microsoft’s Big Data Language U-SQL
Data analytics has become one of the powerful domains in the world of data science. An enormous amount of data is being generated by each organization in every sector. Computer science has found solutions to store and process this data in a smart way through a distributed file system. One such example is Azure Data Lake. It uses the Hadoop Distributed File System, and to perform analytics on this data, Azure Data Lake storage is integrated with Azure Data Analytics Service and HDInsight. In this article, Suhas Pande will explain how to store data using Azure Data Lake and how to perform data analysis on it using U-SQL, a big data SQL and C# language.
2019-04-29
Cloud Identities versus Federated Identities in Office 365
Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?
2014-12-11
8,211 reads
Office 365 Essentials - Subscriptions and Licenses
Should you be planning to move from Exchange to Office 365? If so, why? What sort of license should you get, and should you use cloud identities or federated identities for your users?
2014-08-21
9,937 reads
Cloud Services for the DBA
A critical part of any DBA's role is implementing the systems that will improve in the long term their organization's guardianship, use and understanding of its data. Too often, however, this gets lost in the fog of immediate and urgent tasks. Gareth Marlow explains why he believes Cloud services will play an increasingly prominent role in helping DBAs achieve their strategic goals.
2013-12-06
3,856 reads
Patterns For High Availability, Scalability, And Computing Power With Windows Azure
Now, Internet-hosted distributed applications with connectivity to internal applications—often referred as Software plus Services (S+S)—are gaining popularity. Organizations are leveraging datacenters hosted by third parties to alleviate concerns about hardware, software, reliability, and scalability. These are just some of the new architecture trends that help you build interoperable applications that scale, reduce capital expenditure, and improve reliability. Cloud computing offers many of these benefits.
2009-05-07
2,230 reads
Access Your Data On Premise Or In The Cloud With ADO.NET Data Services
Web Services has been a hot topic for a number of years now, but what, you may wonder, are these Data Services everyone's talking about lately? As the architecture of Web applications has changed and matured (with the popularity of Rich Internet Applications [RIAs], for example), there has been an increased awareness of the value of exposing raw data, minus any interface or formatting, to any service or application that wants to consume it.
2009-05-05
1,623 reads
Blogs
Creating a New Sequence–#SQLNewBlogger
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
An All Star Lineup for EightKB
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Forums
Explanation of Page Splits
Q1 -- I have read quite a few articles on page splits and am...
Script error
I am trying to monitor the sql services on couple of instances and found...
Ask SSC