Guru: Using Sql With Multimembered Files | Latest News RSS feed

Guru: Using Sql With Multimembered Files - Latest News

Guru: More About Merge

Such an expedition recently made me aware that I have not told you as much as I would like to about the SQL MERGE statement ... be the sort of thing you would use in a purchasing application. The data... read more

Open Sourcing GraphQL Guru Server

Immediately I started using apollo-server for my projects. I was in love and the honeymoon lasted a while. As the server grew with multiple files for schema and resolvers ... It is not to be confused ... read more

Deploying a Windows/SQL Azure Solution with Visual Studio Team Build

Deploying a SQL Azure project itself turned out to not be that hard either. Doing so was simply a matter of using MSBuild to call the “Build” and “Publish” build targets in the Microsoft.Data.Tools.Sc... read more

Looking for another news?

Enterprise Data Management in SQL Server 2005

This chapter is from the book In the beta history of the SQL Server 2005 release ... make it easier to work with large batch files and complex queries. Built-in support for source control. Whether you ... read more

Creating PowerShell Scripts

Now that you know what power lies in PowerShell, let's write a simple script to get some info on some SQL services. Much like batch files for the DOS command ... strong programmer or scripting guru (I ... read more

SQL Server version control

In SQL 2005, SQL Server Management Studio is integrated with Visual Source Safe, so a developer using SQL Server Management Studio can check his objects in and out of Visual Source Safe. Ken Henderson ... read more

Installing and Configuring SQL Server Reporting Services

This chapter details the installation and configuration of SQL Server reporting services ... use during installation. If you need to run Setup with command-line options, consider our security caveats, ... read more

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL ... can just use the ring buffer and keep data in memory. I lowered this to 10 events, but you can certainly pick what works for you. If ... read more

Testing the Database Layer

There are a few approaches that can be taken when testing the database layer of your code ... As well as ensuring you’re using your chosen API correctly this technique can verify things that mocking n... read more

Developer Week in Review: Buying a lawsuit with an in-app purchase

Has your SQL been injected? Do you stay awake at night because of cross ... Note: Side effects may include nausea, heart palpitations, and the inability to use Flash or Facebook. Consult your doctor i... read more

Top five T-SQL stored procedures

From finding columns and tables to executing code from a file, Brian Walker's top five stored procedures will offer the simple tricks you need to get routine tasks done. T-SQL guru and senior ... code ... read more

FeedsRSS Created by. Full RSS Feed | Privacy Policy | Contact Us