Using OpenDataSource - SQL School Video
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,677 reads
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,677 reads
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non uncommon cases also keeping up with Facebook, Twitter, and more. Often it's multiple tasks, and we get better at plate spinning.
2009-04-09
1,664 reads
Linked Servers allow SQL Server to access data on other systems, SQL Server, Oracle, Access, Excel, and others. MVP Andy Warren shows how to set one up in this SQL School video.
2009-04-07
6,711 reads
There's been a lot of bad press about 'corporate jets' in the news over the past year. Not that planes themselves have issues, but rather many questions about whether corporations are spending shareholder dollars appropriately. It's not a simple topic, but clearly there did seem to be a lack of awareness about how those kinds of things would be perceived in difficult financial times.
2009-04-01
919 reads
This SQL School video from MVP Andy Warren shows you how to use the OpenRowSet command to access data stored outside of SQL Server.
2009-03-31
3,184 reads
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
2009-03-26
4,691 reads
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
2009-03-26
2,334 reads
In this SQL School video, learn how the UNION statement can help you join together results from different queries. MVP Andy Warren explains this T-SQL statement.
2009-03-24
6,822 reads
The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...The call for speakers is open through midnight on April 10, 2009, so get busy submitting those abstracts! Work hard on the title and description, make it something that seems interesting and compelling for attendees. Expect the competition to be fierce...
2009-03-24
950 reads
This SQL School video shows how you can speed up your backup process by striping the backup across multiple disks. MVP Andy Warren narrates.
2009-03-19
3,633 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers