Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.
BNF Basics
Learn about the basics of Backus–Naur Form. If you've never heard of this, Tom Fischer explores this way of structuring technical information.
Networking for Your Career
It's hard to actually put a specific value on networking, and I've been skeptical of it in the past. However...
Q&A: The skinny on Reporting Services 2008
Get the inside scoop on SSRS 2008 with Michael Lisin and Jim Joseph, co-authors of the new book, "Microsoft SQL Server 2008 Reporting Services Unleashed."
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
Slicing and Dicing
There can be a lot more value when pieces of data are put together than when they exist separately. Steve Jones comments on a few ways people are repackaging information in the modern world.
Where is my app.config for SSIS?
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
Murach’s ADO.NET 3.5, LINQ, and the Entity Framework with C# 2008
Read a sample chapter from this new book about C# and LINQ from Murach.
Post Snapshot Script - SQL School Video
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers