2018-04-20
2018-04-20
WMI has been around for a while and it has grown significantly over the years. With Microsoft's focus on powershell,...
2018-04-20
9,634 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
291 reads
What SQL command do you use to pull and filter data from a table ?
SELECT [Column List] FROM [Table Name]...
2018-04-20
396 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
397 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
206 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
6,610 reads
For one of my clients, I needed to know and document not only database names, size and locations but also...
2018-04-19
439 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item New article
Comments posted to this topic are about the item Monitoring Azure Blob Storage
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers