In-memory tables in 60 seconds
As a SQL Server DBA or developer here is what you should know about memory-optimizedtables (in-memory tables):
Introduced in SQL Server 2014Primary...
2016-10-13
309 reads
Blog Posts
Microsoft Certifications
Every now and again I would navigate to Microsoft’s certification page and see what / if any changes have taken place...
2016-10-13
539 reads
MS Access – Store a Different Value than Displayed in a Combo Box
It is occasionally usefully to display a different values in an Access combo box than what is actually stored in...
2016-10-13
485 reads
My thoughts on Recertifying your MCSE through Microsoft Virtual Academy
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
793 reads
Query shortcuts in SQL Server Management Studio
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from...
2016-10-13 (first published: 2016-09-28)
4,144 reads
Too many indexes!
Indexes are great. They speed up our queries. In fact, without them relational database systems wouldn’t work.
Different indexes work best...
2016-10-13
632 reads
Why I Practice Presentations
I had a new presentation to give this week at IT/DevConnections. This is a paid for conference, and I want...
2016-10-13
859 reads
You don't need any Training? OK...I believe you.
This week's Super duper IT training offers are in:
If you see any that take your fancy let me know. Drop...
2016-10-13
447 reads
An Update on My 2012 Mac Air
Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m...
2016-10-12
438 reads
Check Database Server Workload - Batches/ Sec
Today's post is about a simple but very useful query.
One of the basic things one needs to check is the...
2016-10-12
3,164 reads
Blogs
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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