What is the oldest version of SQL Server you are running?
I have a twitter poll running asking "What is the oldest version of SQL Server you are running?", to use...
2018-01-03
434 reads
How to fix Orphaned Users easily
What are Orphaned Users
“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated...
2018-01-11 (first published: 2018-01-03)
24,514 reads
Dynamics AX Event Session
There are many many uses for Extended Events. In this article I show a quick session setup that can be useful in the troubleshooting of various different problems (most...
2018-01-03
24 reads
Dynamics AX Event Session
Many moons ago, I wrote about how to enable the context info for Dynamics AX. Having the context info enabled...
2018-01-10 (first published: 2018-01-03)
1,153 reads
Power BI Custom Visuals Class (Module 84 – ChartAccent – BarChart)
In this module you will learn how to use the ChartAccent BarChart Custom Visual. This visual is a custom bar...
2018-01-09 (first published: 2018-01-03)
1,583 reads
Absolute computer fundamentals: the command line!
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
410 reads
Implementing Smart Transaction Log Backups Using Ola Hallengren’s Backup Scripts in SQL Server 2017
This is part 1 of 2 part series on taking smart backups. Part 1 will be taking smart transaction logs...
2018-01-02
194 reads
Split Screens (Day 2)
Have you ever wanted to see different parts of the same query window at the same time? Well, in SSMS,...
2018-01-15 (first published: 2018-01-02)
2,337 reads
Upcoming SQLSaturdays
I have the priveledge of speaking at two SQLSaturday events coming up in the near future. This is the first...
2018-01-02
139 reads
Snow, Heathrow Airport, Disaster Recovery
I recently flew from Boston to the UK through the Heathrow airport. It just happened to be on the day...
2018-01-02
700 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Bank BCA KCU PEKALONGAN Telp:0821°8200°203
Telp&Wa 628218200203 Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah 51116
Kantor Resmi BCA KCU MAGELANG Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers