Latest Blog Posts
SQL Server is a database platform designed for providing large-scale transactions, e-commerce applications, data mining, etc. It is widely used on Business platforms for data analysis, data integration and processing components.
Structured Query Language (commonly known as SQL) is a programming language used for managing data held in relational… Read more
0 comments, 108 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 26 April 2016
For those tech professionals who play in the SQL Server and Business Intelligence world (and let me say that’s a huge number!) the PASS Summit provides one of the most fantastic and focused learning and networking experiences available.
I simply cannot think of any other SQL/BI event that… Read more
The SQL Server team is implementing an Incremental Servicing Model (ISM) to deliver updates for SQL Server. This is basically a fancy way of saying: Cumulative Updates (CUs) will no longer be shipped when the team feel it’s required, instead a new CU will ship every 2 months.
This scheduled… Read more
I had someone ask me last night if this statement would create a permanent table in tempdb with a strange name or a global temp table:
CREATE TABLE tempdb..##mytable
( id int
My suspicion was that this would always be a temp table, but since I usually don’t include… Read more
It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s time to take a quick break. For the break, here’s a summary of the most popular links and content that I shared out in the past week through this… Read more
Two IT Pro Camps coming up, register soon!
- IT Pro Camp – Jacksonville FL – June 11 at Keiser University
- IT Pro Camp – Tampa FL – Rasmussen College – Sat, August 20th
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new MCSA (well new 6-8 years ago) we were required to take the data exam (70-461), the admin exam (70-462) AND the BI exam (70-463). I know a number… Read more
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition to a filegroup. It also indicates the next used filegroup if one was specified. Sometimes it is useful to know which partition maps to which filegroup as well as which… Read more
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to do it as a speaker. I look forward to seeing you there!
If you don’t know what SQL Saturday… Read more
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more work and time, but to see someone who is interested in SQL Server as a career take time to learn on a Saturday, makes it all worth the effort. When… Read more
Next week I am participating in two exciting webinars that I want to share with you!
Application availability is an “across the stack” problem – straddling the… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I wanted to make a quick note on changing the sa password, as this is a sensitive account, and the password should be changed if you ever… Read more
Pricing Azure SQL database is difficult because various database service tier options such as database transaction units (DTU’s), max database size, disaster recovery options, and backup retention days are used to determine pricing instead of hardware (CPU/RAM/HD). Generally I recommend starting out with a low service tier and scaling as… Read more
Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway… Read more
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can remotely connect to powershell sessions using the Server Manager that comes with Windows Remote Administration Tools but it’s a bit of a clicky process and I like to eliminate using… Read more
We’re lucky enough to have two PASS chapters here in Orlando, oPASS and MagicPASS. Both in Orlando, but about 40 miles apart, Orlando being the metro sprawl area that it is. Back when we nervously made the decision to launch MagicPASS we also talked through the implications for SQLSaturday and… Read more
Here is a simple example of a LEFT JOIN that returns the sales stats for all employees under 21.
SELECT e.Name, COUNT(s.SaleId) AS Sales, MAX(s.DateOfSale) AS LatestSale FROM Employees e LEFT JOIN Sales s ON e.EmployeeId = s.EmployeeId WHERE e.Age < 21 GROUP BY e.Name
This will return all employees… Read more
I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board of Directors (BoD) presenting pre-cons at SQL Saturday events. It’s potentially a legal issue, and conflict of interest. I’m glad that the issue is being raised, and discussed publically. Here’s… Read more