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
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
Marcin Policht provides an overview of a number of new features that facilitate Azure SQL Database business continuity.
2018-08-28
2,456 reads
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
Erik points out a few things that SQL Server should offer to configure by default.
2018-08-24
4,779 reads
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
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
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
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
Before you go live, test your backup and CHECKDB speeds.
2018-08-17
4,748 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
menghubungi Tanya Jago via WhatsApp resmi (+62821-714-2959/0813-2244-602), Call Center 1500 746, fitur "Lupa Password"...
dapat dilakukan dengan menghubungi Tanya Jago melalui WhatsApp resmi di 08132244602 atau +62821-714-2959, menghubungi...
Cara membuka blokir Bank Jago Terbokir saat transaksi dapat dilakukan dengan menghubungi layanan Tanya...
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers