A Presenter’s Guide to the Stack Overflow Database
Brent shows you how the table joins work and points out some neat data distribution issues.
2018-08-31
2,766 reads
Additional Articles
Introduction to PowerShell with SQL Server Using Invoke-SQLCMD
PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be used to administer SQL Server or even just export data. In this article, Greg Moore demonstrates how to use the PowerShell cmdlet Invoke-SQLCMD to export data from SQL Server.
2018-08-30
3,780 reads
Handling error converting data type varchar to numeric in SQL Server
Error converting data type varchar to numeric may occur when trying to import data that looks like numbers, but doesn't act like a number. Read how to solve this issue.
2018-08-29
3,130 reads
Azure SQL Database Business Continuity Enhancements
Marcin Policht provides an overview of a number of new features that facilitate Azure SQL Database business continuity.
2018-08-28
2,456 reads
The Crimes of Chicago: Working with Data in MongoDB
NoSQL databases like MongoDB are gaining popularity, but using the right tools for the job at hand is most important. In this article, Phil Factor demonstrates how to work with a MongoDB database and how to use PowerShell with MongoDB so that the process can be automated.
2018-08-27
3,230 reads
Setting Up SQL Server: People Still Need Help
Erik points out a few things that SQL Server should offer to configure by default.
2018-08-24
4,779 reads
Azure DevOps: Show Me the JSON!
Creating resources in Azure, while not difficult, can be time consuming if you use the manual steps. One way to automate the process is by using JSON templates to save time and enforce standards. In this article, Brian Flynn describes how to create JSON templates for deploying a network with virtual machines.
2018-08-23
3,050 reads
Granting View Definition Permission to a User or Role in SQL Server
In SQL Server 2005 by default users of a database that are only in the public role cannot see the definitions of an object while using sp_help, sp_helptext or the object_definition function.
2018-08-22
3,287 reads
How to Resize tempdb
When you are setting up a new SQL Server machine you need to determine how big you should make tempdb. To make sure you size tempdb appropriately you should monitor the tempdb space usage. If there are autogrowth events occurring after you have recycled SQL Server than you might want to increase the size of your tempdb data files. If tempdb never uses most of the tempdb space, then you might want to consider decreasing the size of tempdb.
2018-08-21
4,154 reads
Power BI Introduction: Power Query M Formula Language in Power BI Desktop — Part 6
In this article of the Power BI series, Robert Sheldon demonstrates how to work with the Power Query M language to import and transform data.
2018-08-20
2,844 reads
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers