One way of getting the advantages of the Cloud without having to migrate the entire database is to just maintain a copy of the data that needs to be accessible to internet-based users in Windows Azure SQL Database. There are various ways of keeping the two in sync, and Feodor Georgiev describes a solution based in using SSIS.
2013-05-28
3,252 reads
When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. How do you update the TCP port after the installation in a clustered environment for the named instance?
2013-05-27
4,419 reads
In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.
2013-05-24
4,528 reads
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
2013-05-23
3,650 reads
Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.
2013-05-22
5,165 reads
I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?
2013-05-21
3,108 reads
It is increasingly likely that DBAs are now given responsibility for maintaining Azure SQL databases as well as conventional SQL Server databases. What is likely to be required by way of maintenence? What are the differences? Grant Fritchey covers what you need to know.
2013-05-20
2,964 reads
Once you've prepared an SSRS report, it needs formatting to get it ready for the people who need to read it. This tip covers the basics of formatting SSRS Reports.
2013-05-17
4,234 reads
There are several frameworks for assisting with the testing of SQL Server databases, but tSQLt is popular because it is written in TSQL and is simple for a database developer to set up and use. It doesn't get in the way. Rob Sheldon shows you how to get started.
2013-05-16
5,333 reads
When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.
2013-05-15
3,128 reads
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Comments posted to this topic are about the item When the Token Meter is...
Comments posted to this topic are about the item Understanding Temp Tables and Table...
Comments posted to this topic are about the item The Data API Builder MCP...
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers