Power BI and Data Security – App Workspaces and Power BI Apps
Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and...
2017-08-07
852 reads
Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and...
2017-08-07
852 reads
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
195 reads
The syntax for creating a table logically follows many of the same steps that you did when using the GUI,...
2017-08-07
302 reads
Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...
2017-08-07
333 reads
I have the pleasure to announce I’ll deliver a webcast for MSSQLTips.com at the August 24th of 2017. The webinar...
2017-08-07
297 reads
Once you go cloud, there is no going back. This is false and from a database perspective you can migrate...
2017-08-07
450 reads
The Good, the Bad, and the Ugle¯e¯ (need to avoid copyright infringement ?? )
SQL Server 2017 is soon to be officially...
2017-08-07
2,379 reads
Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a...
2017-08-07
601 reads
Diagraming and Documentation
Previously, I've written up on database diagramming for visualization of database structures. Check that out for more detailed...
2017-08-07
775 reads
update 2019-02-22
Image links broken. Since their product is continually improving, I'm going to just link to their product here instead so you can review their latest demo content there....
2017-08-07
26 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
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