Stop or Start, Big or Small. The Scalability of Azure SQL Data Warehouse
Learn how to scale an Azure SQL Datawarehouse up or down, and how to pause it when not in use.
2017-04-10
535 reads
Learn how to scale an Azure SQL Datawarehouse up or down, and how to pause it when not in use.
2017-04-10
535 reads
Is 'Always Encrypted' SQL Server 2016's most widely important new feature? It is significant that 'Always Encrypted' in SQL Server is in all editions of SQL Server. Because of the increasing importance of encryption to data governance, it allows encryption for the sensitive application data for everywhere beyond the application's client connection, including network, server, database and storage. Robert Sheldon explains what it is, why you should try it out, and how to set about it.
2017-04-10
4,486 reads
2017-04-07 (first published: 2015-11-11)
13,128 reads
Learn about the time savings, blocking scenarios, limitations and more for the SQL Server 2016 online ALTER COLUMN operation.
2017-04-07
3,544 reads
Don't waste memory in a cluster! Learn how to allocate memory between instances.
2017-04-06
3,147 reads
2017-04-05
188 reads
Learn about Azure SQL Data Warehouse and how to get started.
2017-04-05
1,111 reads
Because PowerShell needs to be usable as an immediate scripting language by IT professionals who type in commands at a console, there have to be language devices such as aliases that can make for terseness when appropriate. There are several ways of cutting down the verbiage in a script, and being able to specify default values via $PSDefaultParameterValues is one of the more generally useful ones. Michael Sorens explains how it can save you time in your daily work.
2017-04-05
5,035 reads
Audit your SQL logins to find passwords that have never been changed or that are very weak.
2017-04-04
4,482 reads
Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.
2017-04-04
4,187 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers