Issue while using SQLCompare against Azure SQL DB
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
329 reads
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
329 reads
Central Management Servers give us a way to manage a collection of SQL Servers as one, a query executed against...
2018-05-15
88 reads
I find myself using Apply more and more in my queries, aside from the usual reasons I’ve been finding I...
2018-05-14
53 reads
Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...
2018-05-14
269 reads
Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.
2018-05-14
354 reads
I enjoy themes, and when I ran across the SQL Prompt Treasure Island, I had to take a few minutes...
2018-05-14
313 reads
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
128 reads
I do not always use the Azure portal to make database changes or to check for certain information. I use...
2018-05-14
336 reads
Twice recently, one on a blog post, and one in a forum post, I’ve seen people state, unequivocally, without reservation...
2018-05-14
339 reads
MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as...
2018-05-14
216 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...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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