TGI SQL Friday - 16th September 2016 Weekly roundup
I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an...
2016-09-16
454 reads
Restoring Azure SQL Database
A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering...
2016-09-23 (first published: 2016-09-16)
1,239 reads
"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!
I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.
As a SQLSat...
2016-09-15
383 reads
Quick #SQLPrompt Tips – Expanding Wildcards
I tend to try and get code on the screen quickly and then start to remove things. I’m a visual...
2016-09-15
623 reads
#SQLSpeaking this Fall!
I have some great speaking dates coming up this Fall - here is the list:
--
First - the big one. I am honored...
2016-09-15
430 reads
Emojis in SQL Server
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures...
2016-09-15
1,320 reads
Power BI Custom Visuals Class (Module 16 – Bubble)
In this module you will learn how to use the Bubble chart Power BI Custom Visual. The Bubble chart allows...
2016-09-22 (first published: 2016-09-15)
1,544 reads
Great Value IT Training - Awesome ITIL offers
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
387 reads
Sql Server - Detecting and Monitoring Memory Pressure
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
489 reads
More PowerShell for the Azure World
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
501 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor BCA KCU SOLO SLAMET RIYADI Telp:0817°825°533
Telp/Wa 62817825533 Jl. Brigjen Jl. Slamet Riyadi No.3, Kauman, Kec. Ps. Kliwon, Kota Surakarta,...
Kantor Resmi BCA KCU PURWOKERTO Telp:0817°825°533
Telp/Wa 62817825533 Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten Banyumas,...
Question of the Day
Adding Bits I
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