We have been considering lots of changes at SQLServerCentral, but we would like to get comments and feedback from the community as we move forward. This is the start of an series looking at potential and current changes.
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
Although it is well-known how to create a tabular database in PowerPivot, it is less obvious that there are several useful options for retrieving SSAS tabular data into Excel. This provides an easy way of manipulating, visualizing and analyzing the data without needing to know the details of SSAS and the tabular model.
This Friday Steve Jones looks forward to the rest of the year. It's almost time for school and do you have plans? Should you be making some plans?
This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.
Come to SQL Saturday New York on August 17 for a day of free SQL Server training and networking. Some of the speakers at this event include Chris Bell, Ben DeBow, Ashish Sharma, and Hilary Cotter
Many IT enterprises are starting pilot projects to implement big data solutions. This article highlights what you need to know to check if you're ready to support these efforts, and integrate them into your current architecture, processes, and standards.
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
Humans are often the weakest links in any computer process, but we do need human input. Steve Jones talks about a few issues, and how we should be changing our workflow to reduce issues.
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
phone/Wa, Cs. 0817844112 Jl. Ahmad Yani No.31, Pattunuang, Kec. Wajo, Kota Makassar, Sulawesi Selatan...
phone/Wa, Cs. 0817844112 Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...
I have 13 restricted views in my EDW DB. 6 of them are created...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers