Move Azure SQL Databases using the Export and Import PowerShell cmdlets
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
2017-03-08
3,664 reads
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
2017-03-08
3,664 reads
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
2017-03-07
1,615 reads
Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.
2017-03-07
4,670 reads
Join the SSIS Catalog Compare v2.0 Launch Event on Tue, Mar 7 at 13:00 EST.
2017-03-07 (first published: 2017-03-03)
6,163 reads
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
2017-03-06
1,487 reads
The SQL Server Luxembourg User Group invites you to join us at our next event in Microsoft’s Offices, at 6:00pm on Tuesday 7th March
2017-03-06
557 reads
Greg Larsen explains how you can use Dynamic Management Objects and stored procedures to return your worst performing T-SQL statements.
2017-03-06
5,202 reads
This article exlores the usage of CTEs as a replacement to cursors in order to generate additional data by applying logic to existing data.
2017-03-03 (first published: 2013-06-18)
37,939 reads
Bhavesh Patel shows how to clone a SQL Server login onto another server while keeping the password the same.
2017-03-03
4,570 reads
A short demonstration on how to configure Reporting Services (SSRS) with an SSL certificate.
2017-03-02
147,619 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