Monitoring and Tuning Azure SQL Database at SQL Saturday Jacksonville and 24 Hours of Pass
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
317 reads
I’m speaking at two upcoming events that I wanted to share with you! My topic is Monitoring and Tuning Azure...
2018-04-20
317 reads
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
12,347 reads
USE master
exec sp_MSforeachdb '
use [?]
print ''?''
print cast(databasepropertyex(''?'', ''Updateability'') as varchar(200))
if databasepropertyex(''?'', ''Updateability'') = ''READ_WRITE ''
dbcc shrinkfile(2,1)
'
2018-04-20
329 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
468 reads
2018-04-20
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
615 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
12,514 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
8,174 reads
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
15,923 reads
A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that...
2018-04-19
1,001 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