The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,413 reads
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,413 reads
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
114 reads
Ameena Lalani looks at cascading updates and deletes when using temporal tables in SQL Server.
2017-12-25
3,228 reads
Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.
2017-12-22 (first published: 2010-05-18)
8,329 reads
Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost.
2017-12-22
3,997 reads
SQL Server orphaned users are a common thorny issue in auditing. In this post, Jeffrey Yao provides a few different ways of identifying orphaned users covering various scenarios.
2017-12-21
3,707 reads
As the final entry in this series, Robert Sheldon leads you through a group of forgotten features that have been removed from recent versions of SQL Server. In some cases, the features were widely used and often loved, while others had lost their usefulness over the years or were replaced with something much better. In this article, he remembers Data Transformation Services (DTS), a handful of DBCC commands, a few utilities, Active Directory Helper Service, English Query, Web Assistant, SQL Mail, Native XML Web Services, Notification Services, SQL Distributed Management Objects, Surface Area Configuration Tool, and the Pubs and Northwind databases.
2017-12-20
3,745 reads
This time we will show how to access to Azure SQL Data Warehouse using Excel.
2017-12-19
648 reads
You can use the Data Migration Assistant (DMA) tool to migrate your SQL Server instance to an on-premise SQL Server 2017 or to Azure SQL Database. DMA analyzes data migration issues and provides recommendations to resolve them. Read on learn about the features of DMA and how DMA eases your SQL Server instance migration as well as reduces overall risks, allowing you to complete the migration successfully.
2017-12-19
3,471 reads
In order for your team to be productive, communication and collaboration are essential. Collaboration tools allow you to get the most out of your team members.
2017-12-18
753 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